[CI/CD Improvements] Standardize and automate formatting for workflows

[mikealfare]

Is this your first time submitting a feature request?

• [X] I have read the expectations for open source contributors
• [X] I have searched the existing issues, and I could not find an existing issue for this feature
• [X] I am requesting a straightforward extension of existing dbt-snowflake functionality, rather than a Big Idea better suited to a discussion

Describe the feature

As a maintainer, I want to automate formatting checks, so that I can focus more on content in PRs and still maintain a code quality standard.

## Acceptance Criteria
- [ ] A formatter runs as part of `pre-commit`, use the same one as `dbt-postgres`
- [ ] A linter runs as part of `pre-commit`, use the same one as `dbt-postgres`
- [ ] `docs-issue`, `stale`, and `triage-labels` are updated to use the naming standards below (other workflows will be updated as separate stories; these workflows require no other changes)

Style standards:

• Job ids, step ids, and variables are in kebab case
• Job names, step names, and description fields follow dbt docs standards (capitalize first word only)
• Extra descriptors should be avoided unless required for disambiguation, e.g.
  • version-number -> version
  • archive-name -> archive
• Workflow files use a four space tab
• Scripts (inline or separate files) use environment variables in env instead of inline substitution like ${{ inputs.value }}

[mikealfare]

This issue is consolidated into https://github.com/dbt-labs/dbt-snowflake/issues/1004.