Catnip - Is it Good for Cats?

Catnip has a mysterious past. It can make a cat happy, but does it do any harm?