When is it Sunnah to slaughter the 'aqīqah?
All praise is due to Allah, and may peace and blessings be upon our Master, the Messenger of Allah.
It is Sunnah for the 'aqīqah to be slaughtered on the seventh day from the birth of the newborn. According to the sounder position, the day of birth itself is counted as the first of the seven days. Thus, for example, if the child is born on a Saturday, the 'aqīqah is to be slaughtered on the following Friday. If the child is born at night, the count begins from the day that follows. And Allah Almighty knows best.
What is the ruling on public street water if it gets on a person's clothes or body?
The default ruling is that public street water is pure (tahir). If one is certain of its impurity (najasa), then a small amount that gets on the lower part of a person's clothes or body is overlooked (excused). And Allah the Almighty knows best.
Is Zakah (obligatory charity) due on the Zakah money received by a poor person, and reached a Nissab (minimum amount liable for Zakah), and a whole lunar year had lapsed over having it in his possession?
Yes, the poor who possessed a Nissab for a whole lunar year is obliged to pay the Zakah due on that money even if it was given to him as a Zakah money in the first place. And Allah 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.