A parliamentary committee has declared it has no confidence in a water company’s leadership following a damning report setting out its failures.