Is the `Iddah (waiting period) of the divorced effective from the time the divorce took place, or from the time of registering it at the court?

It is considered effective from the very moment her divorce took place, but not from the time of registering it at the court. And Allah Knows Best.

What is the ruling on staring at the Holy Ka'abah?

All perfecy praise be to Allah, The Lord of The Worlds and may His Peace and Blessings be upon our Prophet Muhammad and upon all of his family and companions.

Staring/looking at the Holy Ka'abah is an act of worship even if this took place while performing a prayer, since Al-Baihaqee stated that the Prophet (PBUH) said: " Staring at the Holy Ka'abah is an act of devotion." [Sho'aab Al-Imaan]. And Allah Knows Best.

What should a person who was favored from Allah with a newborn, but couldn`t afford an Aqeeqah, do?

Aqeeqah (the sheep slaughtered on the seventh day from the child`s birth) is a desirable Sunnah for the financially able since Allah, The Exalted, charges not a soul beyond its capacity. Therefore, if the father couldn`t afford the Aqeeqah before the end of his wife`s confinement, then it isn`t due on him, and if he was able to afford it later on, then it is permissible, but if he didn`t until the child reached puberty, the latter can offer the Aqeeqah himself.

My brother is settling a debt on my behalf and in return he takes 30% interest as an additional amount of the whole sum. Is this lawful or not?