It sounds like you know that RTC chips exist that let you set alarms. They’re reasonably low power and have a crystal. Sounds like what you want, if you’re looking for long (multiple second to 24 hour) delays.
Past that, you could program any 6 or 8 pin microcontroller to do the job for you. If you already have a low-power mode, though, just use it.
phil:
What I really meant to say was that although micros like AVRs do have low power/sleep modes (I think) they still use more current than this ‘product’.
Using the low power Timer 1 on Microchip’s nanoWatt series consumes 2-3 uA. So Leon’s suggestion of the 10F or even the 16F series might do the trick.