NGWA's groundwater-use compilations are a convenient resource for the industry market information you want to know:
Ground-Water Availability in the United States (USGS Circular 1323) also provides useful regional information for state and local agencies, along with providing the building blocks for a national assessment of this resource.
Water, People, and the Future: Water Availability for Agriculture in the United States (CAST Issue Paper Number 44, November 2009) discusses the diverse demands for water resources — past, current, and future — using the impacts, regulations, challenges, and policies of specific U.S. states as examples