What should the one performing the slaughter say at the time of slaughtering 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 to say the following supplication at the time of slaughtering the 'aqīqah:
"Bismillāhi wallāhu Akbar, Allāhumma laka wa ilayka, hādhihi 'aqīqatu fulān."
("In the name of Allah, and Allah is the Greatest. O Allah, this is for You and unto You — this is the 'aqīqah of [the child's name].")
This is based on what al-Bayhaqī narrated in Al-Sunan al-Kubrā (Vol.9/P.511), that the Prophet ﷺ said: "Slaughter it in his name and say: In the name of Allah, and Allah is the Greatest. O Allah, this is for You and unto You — this is the 'aqīqah of so-and-so."
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.
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.