The late Queen Elizabeth II pampered her corgis and Prince Harry has revealed their VIP treatment in his memoir, Spare