pond in sandy soil

Hey Everyone! I wanted to run a pond scenario by you guys and see if anyone has any experience here.

I have very sandy soil with SOME clay at about 14ft. I'm not against going this deep but I worry that the material will not even be dense enough to seal. Would you chance it and dig it up or look toward some other method of sealing? I'm not in a hurry to get it filled this season so I'm definitely open to running pigs through it for a while (if this even works). I'm also open to lining it but would like to avoid it if possible.

The proposed size is about 50ft x 50ft-ish and the end goal is fish production. The area has VERY little slope so this would be almost entirely in ground.

Thanks!

What kind of testing have you done so far?

What kind of source do you have access to that is going to fill the pond?

What kind of equipment do you have access to? If you own your own large excavator then the feasibility of a plan is going to be different than if you would be doing this all with a shovel and bucket.

(Also, double check local regulation on water harvesting and usage. Some areas don't bat an eye if you're not working directly in a water course, others are VERY restrictive if you do anything that impacts water feeding down stream.)