A major review called for oversight of water companies in Wales and England to be overhauled.