What is the best manner in distributing the meat of the Aqeeqah?
It is better to divide all of it as cooked meat amongst the poor and the needy. Dividing it into three portions is a Sunnah, but it is permissible to keep all of it provided that a portion, even a small one, is given to the poor and needy (one kilo for example).
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 is the ruling on performing ablution (wudu') and ritual bathing (ghusl) with Zamzam water?
It is permissible to perform ablution and ritual bathing with Zamzam water. However, scholars disliked using it for cleaning after relieving oneself (istinja'). And Allah the Almighty knows best.