'He humanised the Royals and gave them relatability': Cecil Beaton photographs on display in Leeds include portraits of Queen Elizabeth II, Marilyn Monroe, Julie Andrews and Fred Astaire