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 of Islamic Law on leaving the Sunnah prayer of Dhuhr due to fatigue?
Praise be to Allah, and peace and blessings upon our master, the Messenger of Allah.
According to the general rule, a Muslim should strive to maintain the Sunnah prayers before and after the obligatory prayers (al-sunan al-qabliyyah wa al-ba'diyyah). One is permitted to pray them sitting from the outset, but if one leaves them due to severe fatigue, there is no objection to doing so. It is recommended (mustahabb) to make up (qadā') a time-bound supererogatory prayer (nafl mu'aqqat) at any time if it was missed.
Al-Shirbīnī (may Allah have mercy on him) said: "If a time-bound supererogatory prayer is missed, it is recommended to make it up according to the more authoritative view (al-azhar), based on the hadith recorded in the two Ṣaḥīḥs: 'Whoever sleeps through a prayer or forgets it should pray it when he remembers it.' This is also supported by the fact that the Prophet (peace and blessings be upon him) made up the two rak'ahs of Fajr when he and his companions overslept in the valley and missed the dawn prayer until the sun had risen [narrated by Abū Dāwūd with an authentic chain]." And Allah, the Most High, 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.
Should a prayer performer who forgets to offer the middle Tashahod (saying ash-hadu anala ilaha ila-alah) offer Sujood As-Sahw (prostration of forgetfulness)?
He/she should offer two prostrations of forgetfulness at the end of the prayer. And Allah Knows Best.