An Islamist attack on a hotel in Mogadishu ends after 29 people has been killed during a siege lasting nearly 12 hours, police says.