Find the best neighborhoods for waterfront living with practical tips on lifestyle, flood zones, insurance, access, and long-term value.