I use dashboard tablets and old Android phones running the Fully Kiosk Browser along with the Fully Kiosk Browser Controller for this purpose.
For best performance use sound files of your choice that are preloaded on the tablet or phone. Also supports TTS and much more.
A simple app or RM plays the sound file when a contact sensor opens.
Should it matter it's local Wifi, not Zigbee.
