When is Istikharah (guidance prayer) Du`a offered, before Tasleem (saying asalamu alikum warahmatu allah wa barakatuh to end the prayer), or after it?
It is offered after Tasleem.
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.
Is it permissible for a woman to sit with her brothers-in-law?
It is impermissible for a woman to sit with her brothers-in-law, and it is also impermissible for a person to have a Khulwa (seclusion) with his sister-in-law.
What is the ruling on swearing an oath by the Prophet ﷺ, and does such an oath take effect according to Imām Aḥmad ibn Ḥanbal, requiring expiation upon its breach?
All praise is due to Allah, and peace and blessings be upon our master the Messenger of Allah ﷺ.
Swearing an oath by a created being is disliked (makrūh) in our Shāfiʿī school. Shaykh al-Islām Imām al-Nawawī, may Allah have mercy upon him, states: "Swearing by a created being is disliked — such as swearing by the Prophet, the Kaʿbah, Jibrīl, the Companions, or the Prophet's family. Al-Shāfiʿī, may Allah have mercy upon him, said: 'I fear that swearing by other than Allah the Almighty may constitute an act of disobedience.' The scholars of the school explained this to mean: that is, something forbidden and sinful — indicating that he had some hesitation in the matter. Al-Imām stated: the established position of the school is that it is categorically not forbidden, but rather disliked. Furthermore, whoever swears by a created being, his oath does not take effect and no expiation (kaffārah) is required if he breaks it." [Rawḍat al-Ṭālibīn wa ʿUmdat al-Muftīn, Vol. 11/P.6]
According to the Ḥanbalī school, however, expiation becomes obligatory upon one who swears by our master the Prophet ﷺ and then breaks his oath. Imām al-Bahūtī al-Ḥanbalī, may Allah have mercy upon him, states: "No expiation is required for swearing by other than Allah the Almighty, even if the oath is broken — because expiation was made obligatory for swearing by Allah and His attributes, out of reverence for His names, and nothing else is equal to Him in this regard... except in the case of swearing by our Prophet Muḥammad ﷺ, for expiation becomes obligatory when one swears by him and then breaks the oath. This was explicitly stated in the narration of Abū Ṭālib, because he is one of the two conditions of the two testimonies of faith by which a disbeliever becomes a Muslim. Ibn ʿAqīl held the view that swearing by any of the other prophets, peace and blessings be upon them all, carries the same ruling." [Sharḥ Muntahā al-Irādāt, Vol. 3/P.441]. And Allah the Almighty knows best.