The waterfront destination worth adding to your travel list