Today I decided to google an answer. Turns out it is a waterphone using a violin bow.
I'm sure you heard this sound before. Often in games it is used as an eureka-moment sound effect.
Oddly enough I can't recall any games or movie scenes at the moment where it is used.