[async] Migrate workflows over from main to async branch

[aron]

This should now use the PyPi package workflow to publish the package to PyPi using a shared, non-user token.

[nickstenning]

You'll also need pypi-package.yaml otherwise you won't get releases when you tag off async.