At least six major areas of the country could face a crisis on quality and availability of water, the Wrap report suggests