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.
What is the ruling on smoking?
All Perfect Praise is due to Allah, The Lord of The Worlds
Smoking is forbidden (Haram) since it is harmful to one`s health as confirmed by trustful physicians, and Islam has forbidden taking anything that causes harm. The Prophet (PBUH) said: "There should be neither harm nor reciprocated harm." [Ibn Majah and Ahmad]. And Allah Knows Best.
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 Muslim to slaughter an Aqeeqah on behalf of someone else, and offer it to him as a gift?
In principle, the guardian is the one who should offer the Aqeeqah (the sheep slaughtered on the seventh day from the child`s birth) because he is obliged to provide for the newborn, and it is impermissible for anyone else to slaughter it on his behalf unless with his consent. However, it is permissible for a person to offer the sheep, or its price as a gift to the guardian of the newborn, and then the latter can slaughter it, or deputies someone else to do that on his behalf.