'Disgusting and unacceptable,' Visitors leave behind trails of trash in waterfront communities