Dig down to the rock and use the excavated material to build berms up around the hole to the depth you want. Since you have ground water that is so close to the surface use a pump to fill it and keep it full. You will need to line the berms with clay or a pond liner since your soil is sandy.

Life is Good on Bremer Pond!