Trying to organize a long weekend trip in September. Having a difficult time trying to decide where to stay (hotel/inn/etc.). I prefer to be on the water, but at times I cannot tell which hotels and/or inns are directly on the water or have a water view. Am not looking for anything fancy, just clean, great location for some family fun! Any suggestions will be helpful! Thank you!