Tanzania's Vice-President Philip Mpango has threatened to resign over a prolonged water crisis affecting residents from the northern Mwanga district.