What is the ruling on eating or drinking during the second Adhan?
It is not permissible to eat or drink during the second Adhan because it announces the break of dawn and the obligation to start fasting. Allah Almighty says {what means}:"and eat and drink until you can discern the white streak of dawn against the blackness of night." [Al-Baqarah/187].
Whoever eats or drinks during this time invalidates their fast, and they must refrain from eating for the rest of the day and make up for the missed fast later.
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.
Is it permissible for a woman to shake hands with her brother-in-law?
It is forbidden for the woman to shake hands with her brother-in-law because he isn`t a Mahram (unmarriageable) of hers.
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.