The rooms above the Pub have their own entrance from a side street so that guest don't have to go through the Pub itself. When we stayed there, there was no noise from the Pub or the street to be heard that could have kept us from sleeping. The host provided us with a map and a leaflet of the town so that we could easily find our way around. This AirBnB is ideally placed if you plan on exploring Kilkenny as it right on what becomes the High Street just a few steps away from the Pub.
The only thing that was not imediately clear to us was how the check-out was handled. In the end we just gave the room key to the cleaning lady. My suggestion - just ask the host again about the check-out. Maybe they just forgot to tell us...