Is there any sensor incorporated on the Passenger Service Unit that tells the masks to deploy when a cabin decompression occurs?
According to this Airliners.net forum post,
The masks are deployed automatically (typically when cabin altitude exceeds 14,000 feet), or can be deployed manually from the flight deck. In addition, if a passenger service unit oxygen door should fail to open, cabin crew can open the PSU door (either inserting a flat object or a special tool depending on the aircraft type) manually.
So basically, the masks are deployed automatically based on sensors, with manual deployment as a primary failsafe and physical access as a secondary failsafe.