Whether it's a lakeside retreat or a family beach getaway, the scenic views and water adventures are never far away at these resorts.