It’s an old urban legend, but I don’t know of any version specifically dealing with a lake. IIRC, there may have been a Twilight Zone episode with a similar story.
I knew it from the Country Gentlemen’s song, “Bringing Mary Home,” which doesn’t mention a body of water.
Here are the lyrics, if you don’t want to watch the 3:37 video.
I found this (somewhat credulous) blog which claims to recount a 1920s incident that features a bridge, although not necessarily over water.
I’ve heard the story, but not in connection with a lake. I think the most common version I’ve heard is that the mysterious woman is dropped off at the house, and seen to go up to the door, whereupon the driver leaves. Then the driver notices she left a sweater in the back seat, goes to return it, and learns the spooky truth from the parents-- she had died in a car accident at the very spot she was picked up, exactly ten years ago to the very night.
Laurie (Strange Things Happen) - Dickey Lee (1965)
The backstory of the song is that it was inspired by a newspaper story, which in turn was probably inspired by the Resurrection Mary legend from Chicago.
There’s a dark spooky dirt road that goes to the Blue Hole. (A man made gravel dig out that filled with water. Turned into not so secret swimming hole).
A bikini’d blond was walking down the road. A group of teens were driving and stopped and asked her did she need a ride. She hopped in the back of the pick up. Two others were back there.
Beer, loud music, bad driving, and cutting up were happening.
Someone noticed the girl wasn’t back there any more.
Thinking she fell out they drove back to look for her.
They decided she just jumped out at some point.
They get to where they were going and they notice her beach towel was back there.
Monday they went back to school. As they were talking about it during the day it gets out a similar event happened to 2 other groups of kids.
There was always a towel left.
Turns out a family that lived close to the Blue Hole had a daughter who drowned there (presumably a great swimmer, no body ever located),all they ever found was her beach towel.
Thus, you have “The drowned girl of the Blue Hole”
ETA, I imagine every community has a similar tale.
Here on the Big Island there are tons of stories of seeing either a young lady or an old woman walking down the road in the middle of nowhere (we have lots of nowhere here!) and giving her a ride. It’s assumed to be Pele, of course.