Any of those chemists with a photo bar (one of those places you can get a pic on cups or canvas). I know Walsh's chemist in mallow and in Togher both have one.
There's a place on wellington road that does exhibition standard prints on a variety of papers. My friend uses them a lot and they look great. I'll try find them there for you. Edit: they're called iophotoworks. If they're too expensive try snapfish online. I've never had a problem with them.