Winchester is a quiet city, though it recently acquired a nightclub. (Only the one, as far as I know).
As far as the academic vs vocational aspect, the distinction only matters in terms of what you choose to do afterwards. If you want to go into social work, the perceived quality of the university is irrelevant to your employment prospects, but if you choose another career, it might make a difference to potential employers. Nottingham has the best reputation in general out of your selection.
In terms of nightlife, I think Nottingham or Cardiff will be your best bet.