Is it required for a discerning child to make the intention at night if they wish to fast?
If a discerning child wishes to fast during Ramadan, they must make the intention at night because intention is one of the pillars of fasting, even though fasting is not obligatory for them.
What is the ruling on istinja' after urination, and is it done with water and soap or with water only?
Istinja' from urine and stool is obligatory. It is permissible to perform istinja' with water alone, or with toilet paper alone. The best way is with toilet paper then water. If one wishes to suffice with one of them, then water is better. 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.
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.