My fiancé and me stayed at the Pumphouse for 2 nights. Noeleen gave us directions to a parking space really nearby which was cheap, so that was great! We didn't get to meet Noeleen herself but we were shown our room and given the keys. The room is small but has all you need, it was very clean and smelled fresh. The bathroom is shared but was also very clean. Towels were provided.
The location is perfect as you won't need a car to get anywhere around in Kilkenny. There are great breakfast, lunch and dinner places all around so it was no problem to find good food.
This is a great place to stay if you are planning on enjoying some of the nightlife in Kilkenny (many of the pubs had live music on the weekend). Note that it is above a pub so you will hear some music of course. No problem if you are out on the town yourself. They stopped before 1pm so that's not too bad.
Overall a great place to stay with a comfortable bed and a perfect location!