Looking through the notification settings in the N900's control panel I see an option for "other notifications".

What we need is for this to trigger a warning LED when the battery level reaches a critical state, say 15% or so.