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.
Is it permissible for a praying person to make supplication in each Sajdah (a prostration) of obligatory prayer?
It is permissible for a praying person, whether praying individually, or in congregation, to make supplication during Sujood (prostration) in obligatory, or voluntary prayers. However, it is disliked for the Imam to do so since he is required to spare the prayer performers any sort of hardship, unless he is leading a certain group who don`t mind him extending the prayer.
What are the pillars of fasting?
The pillars of fasting are intention and abstaining from all nullifiers of fasting from dawn to sunset.
Is it permissible to offer prayer at home, or should it be offered in the mosque?
All perfect praise be to Allah, The Lord of The Worlds. It isn`t preferable for the man to pray at home as praying in the mosque is twenty seven times more rewarding. Therefore, this should motivate him to offer prayers in the mosque. And Allah Knows Best.