Maeve McCarthy is the recipient of the inaugural Ireland-US Council Portrait Award, a prize that underlines our fascination with this compelling genre, writes Riann Coulter