Which takes precedence: the 'aqīqah or the uḍḥiyyah?
All praise is due to Allah, and may peace and blessings be upon our Master, the Messenger of Allah.
The 'aqīqah is an act of worship through which a servant draws closer to Allah the Almighty in gratitude for the blessing of a newborn child. It is a confirmed Sunnah for those who are financially capable, and Allah does not burden any soul beyond what it can bear.
However, the uḍḥiyyah takes precedence, as it is a confirmed Sunnah established from the Prophet ﷺ through stronger and more numerous narrations — indeed, the Ḥanafī scholars hold it to be obligatory. Furthermore, its time is narrow and limited, expiring with the passing of the days of Eid, whereas the 'aqīqah may be delayed until one becomes financially capable of performing it.
And Allah Almighty knows best.
What should a person who was favored from Allah with a newborn, but couldn`t afford an Aqeeqah, do?
Aqeeqah (the sheep slaughtered on the seventh day from the child`s birth) is a desirable Sunnah for the financially able since Allah, The Exalted, charges not a soul beyond its capacity. Therefore, if the father couldn`t afford the Aqeeqah before the end of his wife`s confinement, then it isn`t due on him, and if he was able to afford it later on, then it is permissible, but if he didn`t until the child reached puberty, the latter can offer the Aqeeqah himself.
Is a woman`s prayer considered invalid if non-Mahrams (marriageable men) saw her offering it?
A woman`s prayer isn`t invalidated if non-Mahrams saw her offering it, but she had better pray in isolation.
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.