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.
When the soul leaves the body, does it hear and see? And where does the soul go?
The important thing is that the soul departs while its owner is a believing, repentant Muslim, as this is a good ending. As for the details, they are lengthy. The grave is either a garden from the gardens of Paradise or a pit from the pits of Hellfire. And Allah The Almighty Knows Best.
Is it permissible for one to give the Zakah (obligatory charity) to his indebted brother?
It is permissible for one to give the Zakah to his brother if he was indebted, or poor.
Is it permissible for the father to give the Zakat of his money to his poor married son?
It is permissible for the father to give part of the Zakat to his poor son, if the latter was sound and healthy, because in this case the father isn't obliged to spend on his young son, even though; he is considered one of the Muslims poor. And Allah Knows Best.