One of the most prominent supporters of Syria's President Bashar al-Assad has been killed in a blast at a mosque in the capital, Damascus.