feat(twine): support 'bzlmod' users out of the box (#1572)

Implements a test that starts a [`pypiserver`] and checks
that the publishing with the new machinery still works.

Fixes #1369

[pypiserver]: https://github.com/pypiserver/pypiserver

WORKSPACE

diff --git a/WORKSPACE b/WORKSPACE
index 75c8e56..86a80bd 100644
--- a/WORKSPACE
+++ b/WORKSPACE
@@ -94,17 +94,27 @@
 load("@rules_python//python:pip.bzl", "pip_parse")
 
 pip_parse(
-    name = "publish_deps",
+    name = "rules_python_publish_deps",
     python_interpreter_target = interpreter,
     requirements_darwin = "//tools/publish:requirements_darwin.txt",
     requirements_lock = "//tools/publish:requirements.txt",
     requirements_windows = "//tools/publish:requirements_windows.txt",
 )
 
-load("@publish_deps//:requirements.bzl", "install_deps")
+load("@rules_python_publish_deps//:requirements.bzl", "install_deps")
 
 install_deps()
 
+pip_parse(
+    name = "pypiserver",
+    python_interpreter_target = interpreter,
+    requirements_lock = "//examples/wheel:requirements_server.txt",
+)
+
+load("@pypiserver//:requirements.bzl", install_pypiserver = "install_deps")
+
+install_pypiserver()
+
 #####################
 # Install sphinx for doc generation.