From water to clean energy, there are lots of investment ideas for benefitting from the trillions of dollars likely to be spent in the coming years.