Is it possible to set an alert mail destination on a per-server basis with Managed Host-based Security?

No. Alerts can not be set differently for each policy or computer.
Configuration changes made to properties for one alert apply to the whole.

Reference: Tutorial ‐ Setting up Notification Alert