Hi Dustin, and welcome to the show my friend!
I agree; it is an amazing topo and could definitely yield on big ol' pond/lake. Based on the topo, though, I see one incredibly tall dam at about 30 - 40 feet at the middle. This would likely require professional engineering, permitting, and annual dam integrity inspections. It would also require an equally incredible amount of dirt movement...$$$
I truly hope you are able to bring this one to fruition, but it will be an immense project. It all comes down to bank account.