The Duchess of Sussex penned a heartfelt tribute to her beloved rescue dog, Guy, following his death