[cmake,bugfix] Fixes requiredness of module

Previously, dependencies were not correctly searched for as
required packages. This patch fixes this.
(cherry picked from commit 86f1dc9c31171890d0bcee2ba0238913876a6b69)
[bugfix,cmake] Fixes precendence issues in module path

When working with installed modules, the cmake scripts and
modules of the current module should take precendence over
any installed ones. This was not the case before this patch.

Furthermore, modules downstream in the
dependency tree should be able to overwrite tests in  modules
that they depend on. This patch more caredfully crafts the
CMAKE_MODULE_PATH to reflect the module dependency in it.
(cherry picked from commit d7a1f3261cf07253fc7303bba0715c709264ccb3)