Im in Derwent which is 100% the best college if your looking for a good social life and nightlife. Its the only college with 2 bars and has its own large social events twice a term with themes which make the college well known. Im in standard acconomdation (its the part of derwent that isnt associated with prison haha). Modern built, all updated in 2016/17 so pretty smart. No en-suite although once you get to uni you realised that really isnt an issue. I share a bathroom with 5 other people which is very good.
I wouldn't advise going to Langwith, Goodricke or Constantine as they are far from town and away from the main campus, although there accomodation is very nice, most of it with ensuites and double beds plus sofas in the kitchens. If any of them, Langwith is definitely the most popular, and well known. It is situated next to the glass house which is a good social space.
If you want ensuites on the main campus i would say go to the new part of vanbrugh which is standard acconomdation with single beds but many have ensuites and it is pretty central.
Still nothing is quite as central as derwent - also catered food in derwent is v good.
Pls feel free to ask me any questions