Water regulator Ofwat will be abolished as part of an overhaul of a "broken'' regulatory system, the environment secretary has confirmed.