[cmake] Use new module dependency policy

Timo Kochrequested to merge
feature/cmake-policy-to-reduce-requirements-downstream-for-optional-dune-mods into master

Merge request reports