Kilkee is a lively little spot. My former employers had a house there which I stayed in a few times managed by westcoastholidays as previously mentioned. I know there are hotels in Kilkee that have self-catering apartments but I don't know anything about them. Location wise, I always liked Lahinch, lovely drives to Cliffs of Moher etc. Lovely golf course there apparently if you're in to golf. Kilkee would be a lot further down. Spainsh Point would be in that direction and is a lovely area also.