Mr Tat and I recently stayed at an inn by a harbour in Maine. Our room had a great view of the harbour, oh my, I could live there... in that room that is, the town itself didn't thrill me too much though the restaurants we visited had some gooood food.
Right on the water is where I like to be, generally preferring tropical but I wouldn't discount a harbour, bay, lake, pond, puddle...
Alas, it was for a short time and I'm back now to regular life. Where's my fairy godmother dammit!?