Peer who brought some of the world’s biggest acts to play at his Co Meath home was suffering from cancer