There is a cache located close to where I live that does this exact thing exept instead of an alarm it is a voice recording that you have to use in order to locate the location of the cache. the name of the caches is midnight in the garden of good and evil. the recording only goes off at midnight and a few minutes after midnight.
http://coord.info/GCT3V0