The chief executive of Ofwat is to step down within months as Britain’s embattled water regulator prepares to be abolished by ministers.