Before drawing tenuous comparisons between Enid Blyton and David Bowie, Nicholas Royle invites us to consider the erotic potential of Timmy the dog