Ofwat is set to be scrapped as part of the most significant overhaul of the UK water industry since privatisation.