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 obligatory to have the intention for each day of fasting, or is one intention sufficient for the whole month?
The intention is obligatory for each day of Ramadan because each day is an independent act of worship separate from the others.
The intention must be made at night before the break of dawn, as the Prophetﷺ said: "Whoever does not intend fasting at night, there is no fast for him." [An-Nasa’i]
And he also said: "Whoever does not firmly resolve to fast before dawn, there is no fast for him." [At-Tirmidhi, Abu Dawood, and An-Nasa’i]
Whoever wakes up and eats Suhoor while mindful of fasting has made the intention. Likewise, one who firmly intends at any moment during the night to fast the next day has also fulfilled the intention.
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.
What is the virtue of performing ‘Umrah in Ramadan?
Ibn ‘Abbas narrated: "When the Prophet ﷺ returned from his Hajj, he said to Umm Sinan Al-Ansariyyah: ‘What prevented you from performing Hajj?’ She replied: ‘Abu So-and-so (referring to her husband) had two camels—he performed Hajj on one of them, and the other was used to irrigate our land.’ The Prophet ﷺ then said: ‘Performing ‘Umrah in Ramadan is equivalent to Hajj with me.’" [Narrated by Al-Bukhari]
The Prophet ﷺ also said: "An ‘Umrah in Ramadan is equivalent to a Hajj." [Narrated by Al-Tirmidhi]
For those who miss the opportunity to perform ‘Umrah in Ramadan, there are many other ways to earn great rewards. One of them is praying Fajr in congregation, then remaining in the mosque remembering Allah until sunrise, and praying two rak‘ahs.
The Prophet ﷺ said: "Whoever prays Fajr in congregation, then sits remembering Allah until the sun rises, and then prays two rak‘ahs, will receive the reward of a complete Hajj and ‘Umrah—complete, complete, complete." [Narrated by Al-Tirmidhi]