When I was in Dublin in 04, the Palace Bar had a great session upstairs. It's near the river in that touristy area the name of which I forget. If it's singing you want, check out the Goilin Singers Club. Cheers, Michael