£1.2bn plan to turn sewage waste into drinking water branded a ‘white elephant’