The dog brought the queen 'such joy, whether on walkies helping or curled up by the fire'