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 should the one performing the slaughter say at the time of slaughtering the 'aqīqah?
All praise is due to Allah, and may peace and blessings be upon our Master, the Messenger of Allah.
It is Sunnah to say the following supplication at the time of slaughtering the 'aqīqah:
"Bismillāhi wallāhu Akbar, Allāhumma laka wa ilayka, hādhihi 'aqīqatu fulān."
("In the name of Allah, and Allah is the Greatest. O Allah, this is for You and unto You — this is the 'aqīqah of [the child's name].")
This is based on what al-Bayhaqī narrated in Al-Sunan al-Kubrā (Vol.9/P.511), that the Prophet ﷺ said: "Slaughter it in his name and say: In the name of Allah, and Allah is the Greatest. O Allah, this is for You and unto You — this is the 'aqīqah of so-and-so."
And Allah Almighty knows best.
Is it incumbent on the fiancée to obey her fiancé?
When the woman settles in her husband`s house, it is incumbent on him to provide for her and it is incumbent on her to obey him. Before that, and if the marriage contract had been concluded, then she is lawfully his wife and thus she should abide by custom in treating him, but if the marriage contract hadn`t been concluded, then she should treat him as a non-Mahram (Marriageable).
Is it permissible for a woman to lead other women in prayer?
Yes, it is permissible for a woman to lead other women in prayer. The most knowledgeable among them in the rulings of prayer should act as the imam. She should stand in the middle of the row, slightly ahead of the others.