The 950-year-old artwork has been the subject of Napoleonic fervour, Nazi plots and even a Guinness advert. Now it is in the UK for the first time since it was made