[CI] Replace deprecated SonarCloud GitHub action
Description
Replaces the deprecated sonarcloud-github-c-cpp action with sonarqube-scan-action
Checklist
-
Documentation reflects the changes made. -
Merge Request title is clear, concise, and suitable as a changelog entry. See our contributing docs
References
Closes #1417 (closed)