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.
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.
What is the ruling on water that contains ornamental fish — does it become impure on account of their waste?
All praise is due to Allah, and peace and blessings be upon our master the Messenger of Allah ﷺ.
The water in a pond containing ornamental fish is pure so long as it has not been altered, for a small amount of fish waste (rawth) is pardoned and overlooked — provided it does not change the water.
It is stated in Ḥāshiyat al-Jamal ʿalā Sharḥ al-Manhaj (Vol.1/P.178): "A small amount of hair from a non-edible animal is pardoned, as is a small amount of hair from a riding animal — on account of the hardship involved in avoiding it — and likewise a small amount of fish waste is pardoned, unless it alters the water." And Allah the Almighty knows best.
What should one do if they see someone deliberately eating or drinking openly during Ramadan?
They must enjoin what is right and forbid what is wrong. If they fear harm from that person, they should disapprove of it in their heart but avoid sitting with them if possible. It is also preferable to seek the help of the authorities to prevent them from doing so.