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.
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.
Is it permissible for a woman to offer the obligatory prayer after Adhaan (call for prayer), and before Iqamah (The announcement that the prayer is about to begin) in the mosque?
Yes, it is permissible for a woman to offer the obligatory prayer immediately after the Adhan and before the Iqamah in the mosque. And Allah Knows Best.
Which hour coincides with the last third of the night?
This hour could be figured out by calculating the number of night hours which start at sunset, and end at dawn break, then the total is divided on three to get the result.