Use bundled packages and update CI for publishing

[chlunde]

Description of your changes

Based on work by @jastang in another repo.

Updates the build machinery to build bundled provider packages, as well as publish to crossplane-contrib OCI repos in both DockerHub and Upbound registries.

This is based on the branch for #115 which should be merged first.

xref crossplane/crossplane#3350

I have:

• [x] Read and followed Crossplane's contribution process.
• [x] Run make reviewable to ensure this PR is ready for review.

How has this code been tested

./.cache/tools/linux_x86_64/up-v0.13.0 repository create provider-sql
chlunde/provider-sql created
VERSION=v0.6.0 make build.all
XPKG_REG_ORGS=xpkg.upbound.io/chlunde BRANCH_NAME=master VERSION=v0.6.0 make publish