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 eating and drinking at night after making the intention? Is it necessary to renew the intention?
Eating and drinking at night, even after making the intention (for the next day), does not affect the fast, and it is not necessary to renew the intention after eating and drinking.
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.
What is the ruling on attending relatives` parties held in public halls, or hotels since if we don`t, we will be subjected to their admonition?
If such parties involve mixing between men and women, or forbidden acts such as listening to songs with sinful lyrics, then attending them is forbidden from the view point of Sharia since people`s admonition is nothing compared to Allah`s, The Almighty`s, wrath.