Peter Murray traces the colourful career of Robert Fagan whose art was inspired by antique examples discovered in Rome