Used to live in Kilkenny. Great place, great pubs, awful beer. As The BeerNut said The Wine Centre is the place to go, they have a great selection.
Good pubs are Cleeres, Ryans and Tynans Bridge House. Stay away from the super pubs up the top of John St though.