A multimillion-dollar cash splash on major water infrastructure in North Queensland will "transform" Townsville and "herald a new era" of economic activity in the region.