I'm not sure what to look for but, I would like to send a notification to my discord using a webhook but only when a new thread is created in a specific category. Would I have to extend the core code?
I think custom development is required for this. And in custom development yes you have to extend the core code of the Xenforo thread creation process.
You can follow this docs for creating the development by your own.