There were many, many posters inspired by the Space Age in the 1950s and even into the 60s. NASA has come up with some new posters that are about space exploration, but more akin to the tourist posters common on subway and train platforms in New York, Chicago and London. They are pretty cool. I'll post a few below, with the rest at this link.
Mars is my favorite so far, but the whole series is pretty neat. If you go to the site, you can find out a bit more about these various planets and moons. (And so much does indeed depend upon water. While I tend to think settling the other planets will never make sense from a financial point of view, the presence of water makes it far more feasible than trying to carry water along with everything else.)