A historical gem that supplies water to more than 80,000 Brisbane residents is undergoing a multimillion dollar upgrade more than a century after it first opened.