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 shake hands with her brother-in-law?
It is forbidden for the woman to shake hands with her brother-in-law because he isn`t a Mahram (unmarriageable) of hers.
Is it valid for the 'aqīqah to be performed using the newborn child's own wealth?
All praise is due to Allah, and may peace and blessings be upon our Master, the Messenger of Allah.
It is not permissible for the guardian to perform the 'aqīqah using the newborn child's own wealth, because the 'aqīqah is a voluntary act of giving (tabarru'), and a guardian is prohibited from making voluntary expenditures from the child's wealth. Should he do so, he becomes financially liable for what he spent. And Allah Almighty knows best.
Which is better in night prayer: long standing (Qiyam) or long prostration (Sujood)?
Long standing (Qiyam) is better in prayer. However, a Muslim should also observe tranquility and composure in their prayer.