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.
Is it a condition for the mosque where I‘tikaf is performed to hold Jumu‘ah prayers?
No, it is not a condition for the mosque where I‘tikaf is performed to have Jumu‘ah prayers. However, if a person vows to perform continuous I‘tikaf, and Jumu‘ah occurs within that period, then they must observe I‘tikaf in a mosque where Jumu‘ah is held so that they do not break their continuity by leaving for Friday prayer.
Which is better in night prayer: long standing (Qiyam) or long prostration (Sujood)?
Long standing (Qiyam) is better in prayer. However, a Muslim should also observe tranquility and composure in their prayer.
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.