Add a canonical way to environment variables for the tests

We use pytest-dotenv as a small quality of life improvement:
the environment variables can now be set in env/tests.env.
We also add a template that and make sure the actual file is
ignored by Git as it contains passwords.