Who is responsible for performing the aqiqah?
All praise is due to Allah, and may peace and blessings be upon our Master, the Messenger of Allah.
The one upon whom the 'aqīqah is incumbent is whoever is obligated to financially maintain the newborn — whether the father, paternal grandfather, or mother. It is to be performed from their own wealth, not from the wealth of the newborn child.
As for one upon whom the financial maintenance of the newborn is not obligatory, they may not perform the 'aqīqah except with the permission of the one upon whom it is obligatory — namely, the father. And Allah Almighty knows best.
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.
Should a person feel pleased, or have a virtuous vision after offering Istikhara (guidance prayer) in order to do what he/she had offered it for?
The result of the Istikhaarah is not necessarily that a person sees something (in his dream), or feels pleased, but the most important result of the Istikhaarah is whether a person is enabled to do a given matter or not.
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.