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 women to gather in one of their homes to pray Tarawih?
Yes, it is recommended (mustahabb) for women to pray Tarawih in congregation if they gather, even if it is not in the mosque.
In fact, praying at home is better for them, as it avoids the potential concerns associated with going to the mosque.
What is the ruling on having an intention (Niyyah) for every prayer?
Praise be to Allah, and peace and blessings be upon our Master, the Messenger of Allah.
Intention (Niyyah) is a pillar (Rukn) without which the prayer is not valid. The worshiper must have an intention for every prayer, meaning they must consciously intend the act of worship they are performing. Its timing must coincide with the opening Takbir (Takbirat al-Ihram). It is not a requirement to utter it verbally; rather, doing so is considered a recommended Sunnah. There are three levels of intention:
1-If the prayer is obligatory (Fard): It is mandatory to include the Intent (to pray), the Specification (which prayer, e.g., 'Asr), and the Obligation (recognizing it as a Fard). For example, one should bring to mind or say: 'I intend to pray the Fard of 'Asr.'
2-If it is a voluntary prayer restricted by a specific time or cause (Sunnah Muqayyadah): It is mandatory to include the Intent and the Specification. For example: 'I intend to pray the Sunnah before Zuhr' or 'I intend to pray Duha.'
3-If it is an absolute voluntary prayer (Nafl Mutlaq): It is sufficient to simply have the Intent to pray. For example: 'I intend to pray.'
And Allah the Exalted knows best.
Is it permissible for women to attend Tarawih prayer in the mosque?
Yes, it is permissible for women to attend Tarawih prayer in the mosque, provided they observe modesty, proper covering, and avoid mixing with men.
The Prophet ﷺ said: "Do not prevent the female servants of Allah from the mosques of Allah." [Bukhari and Muslim]