Turn failing water firms into not-for-profit cooperatives, MPs and mayors tell PM