Managing groundwater is an economic co-ordination problem, not a limit to food production. We currently produce crops that are very, very inefficient in terms of water per calorie, because people like them and some jurisdictions like California don't have effective water markets.