Experts from Penn State University have complied a great deal of data regarding water use and hydraulic fracturing. This from the PSU experts:

Each drill site requires between 3 and 5 million gallons of water per frack. Pennsylvania uses about 8-10 million gallons of water per day for Marcellus Shale drilling, which represents approximately .1% of the 9.5 billion gallons of water the state uses daily.

And yes, the vast majority of this water is ultimately recycled and reused for future operations. See more information here about the climbing industry-wide recycle and reuse rates. A small percentage of the water is however taken to EPA-permitted underground injection wells for disposal.