Kate Middleton's younger brother revealed that like the late Queen, the golden retriever puppy was on a path to dedicate his "life to service"