What is the ruling on someone who eats or drinks thinking that the night is still present, then realizes that dawn has broken?
Whoever eats or drinks thinking that the night is still present, then later discovers that dawn has broken, must refrain from eating and drinking for the rest of the day out of respect for the sacred month. However, they must make up that day after Ramadan, and there is no sin upon them.
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.
Can I start fasting based on the moon sighting of another country?
You must follow the moon sighting of the country you are in.
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.