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 istibra' and how is it performed?

Istibra' (cleansing from urine) is recommended. It is for a person to ensure that nothing remains of urine in its passage before performing istinja'. Its method is: to clear the throat (or cough slightly), shake the penis (meaning to pass fingers along it to expel any remaining urine if needed), and walk a few steps to the extent that one thinks nothing of urine remains if walking is needed. Each person knows his own nature best. The preferred opinion is that this differs among people. The objective is for one to think that nothing remains in the urinary passage that he fears will exit later. And Allah the Almighty knows best.

Is it permissible to offer mandatory prayer while sitting?

All perfect praise be to Allah, The Lord of The Worlds, and may His Peace and Blessings be upon our Prophet Muhammad and upon all of his family and companions.                                                                                                                                                                                                                            Standing up is a pillar in the mandatory prayer and the prayer is not valid without it unless one cannot do it. As for Nafila (supererogatory prayer), one can perform it in the state of sitting even if he/she can stand, but his/her reward is half the reward of the person who prays while standing if he/sh has no legal excuse for such an act. And Allah Knows Best.

How is the Night Prayer (Qiyam al-Layl) performed?