I'm surprised no-one mentioned 'Danny Boy' or is it too old hat? I always seem to impress every-one when I sing it: it's great to bring a tear to their eyes! I also like 'Achal by the Sea', but I'm not sure if it's trad Irish or not.