A leading Burundian general and close aide to President Pierre Nkurunziza has been killed in a rocket attack on his car in the capital Bujumbura, officials and witnesses have said.