Riddonkulous

I am a deep, man-made hole in the earth, created by tearing away rock, stone, or sand. I hold secrets of the ground below, yet when I am filled with water, I become a place for a swim. What am I?