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).
What is the ruling on reciting verses of the Holy Quran on water, then drinking it?
It is permissible to recite Quran on water, then drink it as a kind of treatment since the Quran heals. Allah, The Almighty, Says (What means): "We send down (stage by stage) in the Qur’an that which is a healing and a mercy to those who believe: to the unjust it causes nothing but loss after loss." [Al-Isra`/82].
What is the stance of Ahlus-Sunnah wal-Jama'ah regarding the historical figure known as 'the Sufyani,' who some say will appear at the end of times? And what is the stance of Ahlus-Sunnah wal-Jama'ah regarding the group that killed Al-Husayn ibn Ali (may Allah be pleased with them), particularly those who directly committed the killing, severed his head, and killed members of his family?
Most of the narrations about the signs of the Hour concerning the Sufyani, who is said to appear before the Mahdi, indicate that he is the leader of the army that will invade the Kaaba, and Allah will cause the earth to swallow them. We disassociate ourselves before Allah from those who killed Al-Husayn Ibn Ali (may Allah be pleased with them), supported his killing, or encouraged it, whether openly or secretly. The inner matters are left to Allah alone. And Allah The Almighty Knows Best.
Does Istigfar (Asking Allah for forgiveness) between the first and the second part of Friday prayer`s sermon render the prayer invalid?
Talking during Friday prayer`s sermon is disliked, but there is no harm in offering Istigfar between the two parts of the sermon, and it doesn`t invalidate the prayer as it is actually from Sunnah. And Allah Knows Best.