UK water regulator CEO David Black is stepping down as Ofwat plans to be abolished amid water shortages and Thames Water fines.