For all of my life, I have always lived near water - in many cases within walking distance of a lake, a creek, canal, river, or a pond. I cannot imagine living somewhere without a body of water, but I also cannot imagine going through some of the cataclysmic flooding such water can bring. Any floods near me have been, well, not devastating.
I am fortunate to live near Niagara Falls. And it's fortunate that I really like it there. Sure, there is a bit of tacky touristy hell there, but the falls themselves are magnificent and I will happily drive past them at any time of the year. Especially in winter.
Oceans are okay, though with the latest tsunami threats in the Pacific, I'd be happier on a calm cruise in Estonia.
maybe add a few islands
or a waterfall
Rivers in a city are especially attractive as they provide an opportunity for bridges. I have been known to go miles out of my way for a waterfall or bridge. (I've been to Milford Sound, but not Prague)
sometimes, you can't really escape water, and that's fine with me
my happy place: anywhere near water