A picturesque Scottish peninsula immortalized in a hit Paul McCartney song from the 1970s will host a new U.K. rocket development hub.