Implement an automated release workflow in GitHub Actions

[jpower432]

Feature objectives

Add a workflow for automated release and update the security insights file

Caveats / Assumptions

• Automated release is needed for consistent creation of changelong and pre-release verification

Completion Criteria

• Add workflow for automated release (with goreleaser preferred as it is used in C2P Go)
• Update release.automated-pipeline field in .github/security-insights.yml to true