Show a deprecation warning if `no_site_packages` is used. Fixes #6027.

If both `no_site_packages` and `system_site_packages` are used, throw an error.
Added the appropriate tests.