The Princess of Wales' brother, James Middleton, has shared the heartbreaking news that one of his beloved dogs has died.