Update sonarsource/sonarcloud-github-action to be SonarSource/sonarqube-scan-action@v4.1.0

Upgrade the sonarsource/sonarcloud-github-action to [SonarSource/sonarqube-scan-action@v4.1.0](https://github.com/SonarSource/sonarqube-scan-action/releases/tag/v4.1.0).  Also need to look at workflow permissions.

_Originally posted by @rbarkerSL in https://github.com/hashgraph/hedera-mirror-node-explorer/issues/1544#issuecomment-2568460663_
            