Water scarcity will become a defining characteristic of the next few decades. This will end up creating both new opportunities and new risks for investors.