That's definitely a Lake Erie Water Snake. Often times you can't even see markings on mature snakes until they're in water. The pattern is much more visible on young snakes when dry. They are harmless but like most water snakes, they have a bad disposition. Just leave alone and let them do their thing.