I don't think that there is a ready-made solution for this, but I may be wrong. However, you could in theory use beep
https://manpages.debian.org/buster/beep/beep.1.en.htmlfor example, in a script which polls the SMART data. This means that you would need to decide an interval at which to check the data (once a day? Once every hour?) and then check that a value is not exceeded (which ever value you are interested) and then have that script make the sound.
However, you must realize that hard drives many times fail without warning or that the indicator of detrimental change is not a necessarily a number, but how quickly the number changes. SO in this kind of case you would need a more sophisticated decision marker than a simple cutoff (like keep a history of some sort)
Also, this kind of thing might already be programmed into the firmware/UEFI/BIOS, so check that.