Why not use the Rules Engine?
I'm not entirely clear on where the alert needs to be displayed - inside Sitecore or to the visitor of the website, but it could be done in either case:
Inside Sitecore
You could use Sitecore's default (at least in Sitecore 6.5 it's an out-of-the-box Action) Set Content Editor Warning if some Conditions are true (i.e. it's of a specific template, in a specific location of the content tree, etc.). For the warning to show up you'll have to create a Rule in the /sitecore/system/Settings/Rules/Content Editor Warnings/Rules folder
To the visitor of the website
What you could do here is again run some Conditions - there is also an always run type of condition if you want to do this on every page - and Sitecore also has some actions available here: For instance, you could use the default Set datasource to item (the item being where you've saved your warning description) or 'Set parameters to value' - more on using Sitecore parameters here
You could even create your own custom Action or Condition so you could, for instance, add a new Sublayout or Rendering to a placeholder which will display something.
Of course, with setting the datasource to an item it will always take the text in that item - if you edit the original description it'll overwrite the old one, possibly affecting all other items using that description.
Using the parameters will not have that issue, but you'll not be able to re-use text like that, so if you are using it in multiple locations it's not possible to apply one change everywhere.
Content Editors will be able to change the text fairly easily using the Page Editor (especially when using something like setting datasource to item or having a custom field)