Here's what I found by googling at this site:
http://ortho.ftw.nrcs.usda.gov/osd/dat/C/CAPAC.html The Capac series consists of very deep, somewhat poorly drained, moderately slowly permeable soils that formed in loam or clay loam calcareous till. These soils are on moraines and till plains of Wisconsinan Age and typically have slopes ranging from 0 to 6 percent. Mean annual precipitation is about 32 inches, and mean annual temperature is about 47 degrees F.
I'd contact your local NRCS office as Todd suggested. If you are looking to build a dam, you wouldn't want to use this material, since loam is a mix of sand, silt, and clay. You would want to check to see if there is a source of good clay soils close to the surface somewhere near where you want the dam.
If you are looking at an excavated pond, you should probably dig come test holes, fill them up with water, and see if they hold water. Also check land nearby to see if there are any dugouts or ponds that hold water.
Bill
