A lot of people who believe they live in haunted locations report their pets to be hypersensitive to the supernatural activity. Sometimes dogs and cats, or even wild animals, appear to be tuned in to things that we humans don't notice. This is true in the natural, so it makes sense it might also be true in the supernatural.
However, cats are also insane. My cat sometimes bounds up and down the hall, attacks random things, then runs away and hides like something is after him. We might have a ghost skulking around, but usually I take it to mean he needs more attention so he can burn off some energy. Cats are predators made for short bursts of action, and I think they just need to get it out of their system sometimes.