ci: .github/workflows: add staticmajor to catch leaking resources

[odeke-em]

Brings in a static analyzer that catches leaking resources like unclosed file handles, networking handles etc that can't easily be caught except in very critical code reviews as well as a bunch of other static analyzers that Orijtech Inc produces.

Just an FYI for my team @elias-orijtech @kirbyquerby @willpoint

[elias-orijtech]

Please re-run workflow. Latest staticmajor now runs with CGO_ENABLED=0.

[julienrbrt]

Superseded by https://github.com/cosmos/cosmos-sdk/pull/13392