Don't know the unit at all but being a 'Northern Monkey' and having done a few courses there I know the location well. Just on the outskirts of Ripon which is a fairly decent night on the piass as long as you don't mind the odd scrap with the pikey locals. Fancy going further afield, Harrogate is spot on although a little pricey and of course you have York and Leeds just down the A1.
As a bonus, the camp itself is about 5 miles from Masham, the home of 'Black Sheep' bitter which is a cracking pint. Might want to earn yourself some brownie points when you arrive in your unit and organise a brewery tour for the lads.
Excellent Wksps when I was there in the mid 90's, know a few people there at the moment. Ripon itself is a small town but plenty of shops for the missus if your married and a hand full of pubs and small night club and bigger club (Sly's if I remember right).
Its Claro Bks and the fat badges are a good bunch with a lot of plant kit to work on. Spent quite a bit away on tours etc whilst I was there and they had both Cpl's and Sgt Mess there. Supposedly the camps been done up a bit now and I believe Pay as you Starve has come in. Also got an Airborne sqn (51).
Lucky barsteward I wouldnt of minded going back there for my last few years.
Edited to say you will need to purchase a dress as its part of your kit when you go on tours