Add missing dependency on six python package

Adding find_package(six) to ensure we pick up the version from LCG over any locally installed one. Mainly relevant for CI tests.