Check out the Three Stags Heads in the Peak District, about half an hour from Sheffield. Usually a good session in there on Saturday night, plus some superb beer. A "no-pretensions" pub - by the end of the night, you want a pint, you pour it yourself and put the money in the till! Very small, but superb atmosphere, especially on a good evening. And _very_ good food and beer.It's a popular pub with walkers and climbers, and is something of a second home for the Loughborough climbing club (where I found out about it) and often other climbing clubs as well (Sheffield are often there). There's a basic campsite behind the pub, or there's the infamous "pig-loft" (a small straw-filled barn which accomodates about a dozen dead-drunk cheapskate students :-) or there's also a B&B nearby.
One reference...
...and anotherGraham.