You need to be able to compact the dirt together in your hand and it stay together, even in the water, this will give you a rough scetch of what to look for.
Remember, you might want to dig some test holes at about 20 to 25 feet deep to see where the water is at, and to see what kind of material is down there....There have been many of lake projects that have gone BUST because of poor core material....