I live in Sutherland Springs tx and the soil is sand but if you go down a couple feet it's clay.... if you got clay you can dig a pond. There is ponds all in my area some hold water some don't. Think it just depends on how good and experienced your dozer man is. My guy has dug alot of ponds in my area and has a d6 dozer charges$ 95 an hr. I'm sure I could find cheaper but you get what u pay for. Maybe a 10 acre lake might not work but maybe a 2 or 3 acre pond will work.

Cry me a river