A new study shows Americans are drilling deeper than ever for fresh water.