Is there any device that can detect whether a machine is working properly or not based on the sound it produces?

In general, it appears to be possible.

Or is it possible to develop one and how?

One would probably need some knowledge in digital signal processing (for example), and knowledge about the machine one is looking at (which you haven't named). In Perl PDL might be useful, there is for example PDL::FFT.