The effects of well management and the nature of the aquifer on groundwater resources