This hotel will suit you fine and is also very reasonable and well situated to the main nightlife ...
http://www.ichotelsgroup.com/h/d/pc/925/en/hd/ notmm
I agree Nottingham (like any other major city) has its spoils of prats but don,t believe the hype mate its a cracking night out !!!
Depending on what style of music you go for if its rock (ewww) then go to rock city 5 mins walk from market square
Or club music try Media which is also 2/3 mins walk towards rock city ....
There are loads of mainstream clubs just ask around ....
I,d raccommend you have a drink in Hockley which again is 5/7 mins from the market square ... Just jump in a cab it,ll cost 2 or 3 pound tops !!!
Have a great time ... remember its 4 women to 1 man :)
Alternatively you could go down the A52 to the hole namely Derby hehehehe