story(security): enable codeql

### Description

As a maintainer/contributor, I want to enable CodeQL, so that any all code can be automatically analyzed for any potential issues like hardcoded passwords.

### Acceptance Criteria

- [ ] CodeQL is enabled
- [ ] For now default rules for Go are acceptable

### Related Issues

_No response_