It took a long time for cats to gain the same serious status as dogs, but by the 18th century they were starting to have personalities, says Kathryn Hughes