The veteran West Cork-born artist Patrick Scott is the subject of a major retrospective in Dublin and Carlow, Tina Darb O’Sullivan reports