The 100-year-old private club will spend $6 to $10 million, funded by its members’ annual golf dues, to build an on-site, 6,000-sq. ft. facility that could deliver up to 500,000 gallons per day of “effluent for the affluent.”