Waterfront vacation properties remain a hot commodity. A new report calls out the locations that offer the brightest opportunities.