You're refering to the Huron dam. I'm not sure if there is water in it anymore. There wasn't the last time I was there, in the nineties. Huron creek (the one that runs through the Houghton beach area) runs through there, and used to be dammed up. There must have been a break in the dam and all the water ran out decades ago.