ci: Update 'Security Scan' workflow to be reusable

[juanjjaramillo]

Description

Reduce redundant code and simplify code maintenance by making the security workflow reusable.

Type of change

• [ ] Breaking change (fix or feature that would cause existing functionality to not work as expected)
• [x] New feature / enhancement (non-breaking change which adds functionality)
• [ ] Security fix
• [ ] Bug fix (non-breaking change which fixes an issue)

Checklist:

• [ ] Add changelog entry following the contributing guide
• [ ] Documentation has been updated
• [ ] This change requires changes in testing:
  • [ ] unit tests
  • [ ] E2E tests