What is the ruling on swearing on the Holy Quran and breaking that oath?
It is impermissible to swear on the Holy Quran in vain, and it is also impermissible to subject it to such an act since breaking the oath after swearing on the Quran entails an expiation.
Is it incumbent on the fiancée to obey her fiancé?
When the woman settles in her husband`s house, it is incumbent on him to provide for her and it is incumbent on her to obey him. Before that, and if the marriage contract had been concluded, then she is lawfully his wife and thus she should abide by custom in treating him, but if the marriage contract hadn`t been concluded, then she should treat him as a non-Mahram (Marriageable).
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.
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.