Should a person feel pleased, or have a virtuous vision after offering Istikhara (guidance prayer) in order to do what he/she had offered it for?
The result of the Istikhaarah is not necessarily that a person sees something (in his dream), or feels pleased, but the most important result of the Istikhaarah is whether a person is enabled to do a given matter or not.
Is a person who is in a state of Janabah (major ritual impurity due to having a marital intercourse, ejaculation, menstruation, and post-delivery impurities) sinful if he/she goes about his/her daily life activities in that state i.e. without making Ghusl (ritual bath)?
It goes without saying that a Muslim should always be in a state of ritual purity so as to be able to perform prayers and recite Quran. It is from Sunnah (Prophetic tradition) that a Muslim hastens to make Ghusl from Janabah, but he/she is not sinful in case he/she delayed that provided that he/she doesn`t miss prayers. However, it is permissible for him/her to go about their daily activities while in a state of Janabah, but had better bathe in order not to miss any prayer.
What is the ruling on the Friday bath (ghusl al-Jumu'ah)?
The Friday bath is a confirmed Sunnah, based on the Prophet's (peace be upon him) saying: "Whoever performs ablution on Friday, it is good for him, and whoever takes a bath, bathing is better." (Reported by Abu Dawud and al-Tirmidhi who said it is a hasan hadith). It is recommended for everyone who wants to attend the Friday prayer, even if they are not from its usual attendees, like a woman or a boy.
If a person is in a state of major impurity (junub) and intends by his bath both lifting the major impurity and the Friday bath, he achieves both. If he intends only one of them, he achieves only what he intended. And Allah the Almighty knows best.
What is the ruling on performing ablution (wudu') and ritual bathing (ghusl) with Zamzam water?
It is permissible to perform ablution and ritual bathing with Zamzam water. However, scholars disliked using it for cleaning after relieving oneself (istinja'). And Allah the Almighty knows best.