Both are actually crap.
Cork is probably the strictest place in Ireland.
Kilkenny wins hands down
OP is looking for dance clubs. Kilkenny is better than the bigger cities if you're looking for a more relaxed atmosphere but obviously the OP is looking for something a little more exclusive. I don't see how Dublin has any competition in Ireland in that regard.