[Epic] Standard GitHub Actions workflows

[dbeatty10]

Is this your first time submitting an issue in dbt-athena?

• I have searched the existing issues, and I could not find an existing issue for this feature

Describe your request/question

For standardization across adapter repos managed by dbt Labs, most/all of the workflows from here should also be in this repo.

Tasklist

• Workflow 1
• Workflow 2
• etc.

Anything else?

No response