Another (cheaper) option than RFID is to rig a pair of IR detectors across the doorway, one about 6 inches up, one 3 feet up. Hook them both to a microcontoller like the Arduino. When both are triggered at the same time (by a human) don't sound the alarm, when only the bottom one is triggered sound the alarm.
Of course if you have more than one pet this won't work.