Utilize GoReleaser to build nightly and tagged releases

[techknowlogick]

Feature Description

For nightly builds and tagged releases we currently use a mix of makefile, drone yaml, and a few other magic bits. By switching to use goreleaser we could swap that all to yaml configuration, and gain other benefits from using goreleaser such as generating .debs and .rpms and more.

Edit: Out of scope includes, building the Docker images, although perhaps goreleaser would build the binary (possibly inside the dockerfile itself), as the docker image building would be handled by #22009