I'm looking to join a tennis club where I can play tennis in a social setting with a variety of people. Anyone know any good ones?

Have a look at this link

http://www.sdlta.org.uk/clubs.html

Hallamshire is a good one, a bit pricey though. Graves is also good