Add vulnerabilities/security scanning

[leandro-lucarella-frequenz]

Some options:

• bandit is a Python specific tool to find common security issues in Python code.
• CodeQL is a more general GitHub specific solution that supports many languages.

Discussion:

• Have a look at more Python static analysis tools #28

[llucax]

New auto-fix feature for CodeQL:

• https://github.blog/changelog/2024-03-01-codeql-2-16-3-ai-powered-autofixes-for-python-updated-queries-and-security-fixes/