According to wikipedia, the active substance is nepetalactone ($C_{10}H_{14}O_{2}$) which has weak sedative, antispasmodic, febrifuge, and antibacterial effects in human.
Ok, but why are cats so fond ...