The Yemeni army commander leading the fight against militants in the south of the country has been killed in a suicide attack, officials say.