I did a hen night in Leeds - started in Malmaison for lunch and drinks followed by Harvey Nichols (supposed to be shopping) but just ended up in the top floor bar doing more drinking...back to Malmaison to get ready then dinner, more drinks and dancing at Tiger Tiger...it was great fun! When we got back to Malmaison half of Leeds United were in the bar with Mel C of Spice Girls fame!
I second any drinking at the Malmaison or HN in Leeds! I can't comment on the clubs - having given that up ages ago - but there are lots of bars that stay open late that are really nice. There's Living Room/Prohibition on Greek Street that are nice but always packed. If you venture down towards the Corn Exchange there is Oportos which is also nice. There's a few new places that have opened that I've not been to yet like Baroque and a few others. I think Leeds is a good night out - and you can't go wrong if you end up stuck in HN drinking on the top floor!
went on a hen night/weekend there last year (when dd was just 4mths old, bless dh for looking after her whilst I went partying!) we stayed at \link(http://www.devereonline.co.uk/jdevere.htm?http://www.devereonline.co.uk/hotel_oulton\link} Oulton Hall hotel, rather nice I must say! with nice pool, steam room, sauna etc and beauty salon, we all booked in for treatments on the saturday (just what the doc ordered after having dd!) and one the friday night went out around Leeds (cut short by one of our number being a bit ill in Tiger, Tiger.....) but still went back to hotel and had a great time!
Park Plaza nice hotel - very new and central - just near train station and very central for bars etc. "Henrys" is a nice bar - Tiger Tiger - great, the Square - young and trendy, Flares nightclub- retro do not sure what like as not been in.