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 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.
How can I love the prayer (Salah) and start praying?
Praise be to Allah, and peace and blessings be upon our Master, the Messenger of Allah.
Love for the prayer (Salah) comes when you realize that this world is fleeting and the Hereafter is everlasting. Your prayer is the righteous deed that will comfort you in your grave and be your salvation before Allah in the Hereafter. Do you not wish to attain tranquility in this life and Paradise in the next? Reflect upon your state and do not delay, for life does not wait. We ask Allah to grant us and you steadfastness (Thabat).