The Future of Water Investments: Addressing Scarcity and Infrastructure Challenges