This question gets asked a lot and I don't think you can really distinguish between them for 'social life'. The social life at any accommodation in Leeds will be pretty good IMO.
There's a different social atmosphere between catered and self catered. Catered you meet more people, in one offs, self catered creates more family-type units. There's also a different social atmosphere between the more expensive ones and the cheaper ones, predictably the more expensive ones attracts more 'rich kids' and the cheaper ones attract a different type. Other than that I wouldn't say there's masses of difference.
The other thing that gets overrated on here is distance from campus. It's an issue to bear in mind for Bodington and to an extent Oxley, but at all the others, you won't really find the distance or travel an issue at all.