When do I connect to negative terminal or ground?
You should avoid connecting cables directly to your battery. There's no point at all. The negative terminal of the battery is connected to your car body, so you can connect your siren's negative terminal directly to your closest ground point (car metal body). There's no reason to have multiple cables on your battery's terminal. Cable harness will be more organised.