Migrate to codeql yaml file

[dashpole]

Part of https://github.com/GoogleCloudPlatform/opentelemetry-operations-go/issues/734

Based on https://github.com/open-telemetry/opentelemetry-go/blob/main/.github/workflows/codeql-analysis.yml

Right now, we have the "automatic" version of codeQL. This uses github actions, so we can see the status check as a presubmit check on PRs (see below).

[codecov[bot]]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Comparison is base (fbc9917) 69.93% compared to head (be801a2) 70.01%.

Additional details and impacted files

```diff @@ Coverage Diff @@ ## main #774 +/- ## ========================================== + Coverage 69.93% 70.01% +0.08% ========================================== Files 42 42 Lines 4863 4863 ========================================== + Hits 3401 3405 +4 + Misses 1311 1307 -4 Partials 151 151 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

[github-advanced-security[bot]]

This pull request sets up GitHub code scanning for this repository. Once the scans have completed and the checks have passed, the analysis results for this pull request branch will appear on this overview. Once you merge this pull request, the 'Security' tab will show more code scanning analysis results (for example, for the default branch). Depending on your configuration and choice of analysis tool, future pull requests will be annotated with code scanning analysis results. For more information about GitHub code scanning, check out the documentation.