I think that a ground-water sand pond vs. a sealed and compacted clay pond would not require as much pond building experience.

The only recommendations I would have is to make sure and plan for large fluctuations in water level. This means a floating dock that can go up and down with water level and long gradually sloped banks that you can maintain easily when the water is low and wont look unsightly when the water table fluctuates.

With sand, you are unlikely to be able to pump enough water from a well to make up for normal flow through the water table, sort of like farting in a stiff breeze is barely noticed. Before adding the expense of the well, see what your pond does first after a few years of observation.