I don’t know of any non-powered units with sound other than Lionel’s Superbass B-units. I don’t think any modern style dummy diesel has it. Several have smoke. As always, I can be wrong.
Do a search under gunrunnerjohn. He has a recent topic on a new board he is working on that will put sounds into a dummy. This might be your best bet.