The alleged leader of an al-Qaeda cell in Yemen has been killed in an exchange of fire with security forces, according to a provincial governor.