Remove remaining references and tests to no_site_packages

- Removed all remaining references to `no_site_packages`, which is now deprecated. 
- Removed tests checking for deprecated `no_site_packages` argument