A proposed £1.2bn scheme to recycle effluent from the sewage system and turn it in to drinking water has been…