Automatically launch a program or action when an external drive or disk is connected
Marco Polo can perform actions (you specify) based on attached USB devices.

Edit: MarcoPolo isn't supported anymore, but there is a maintained fork of it: ControlPlane