This sound effect can be found on Bells & Sirens, which was made by Castle.
https://soundeffects.fandom.com/wiki/File:Castle,_Factory_Siren.ogg