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.
Some online stores offer a discount on a customer's first purchase — what is the ruling on creating a new account each time a customer makes a purchase in order to obtain that discount?
All praise is due to Allah, and peace and blessings be upon our master the Messenger of Allah ﷺ.
It is obligatory upon a Muslim to uphold honesty in both his words and his actions. Allah the Almighty says {what means}: "O you who have believed, do not betray Allah and the Messenger or betray your trusts while you know." [Al-Anfāl/ 27] And He says {what means}: "O you who have believed, fear Allah and be with the truthful." [Al-Tawbah/ 119]. And the Messenger of Allah ﷺ said: "Whoever deceives us is not of us." (Reported by al-Bukhārī.)
As for creating a new account for the same buyer, the terms and conditions of the website must be observed and respected. If doing so violates those terms, it is not permissible. And Allah the Almighty 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.
Can I start fasting based on the moon sighting of another country?
You must follow the moon sighting of the country you are in.