Its appealing, but risky. The drip line of the trees shows that some roots have made there way to the water. I would do a little more research to see exactly what your liability would be if you did nothing to the dam. What does the emergency overflow look like? Would the seller be willing to assume the long term liability in writing in a land contract? A good real estate lawyer would be my 1st order.