The son of Irish emigrants, John Brennan was this week announced as Obama’s choice to head up the CIA. Caroline O’Doherty investigates