CMake improvements

• Refactored the ctest to not use globbing and more modern structure
• Added missing dependencies. @micael.oliveira or anybody please take a look at the available packages, which are missing, etc.
• Added failing_tests to filter for known failing tests. Currently added the spglib failing tests from !1913 (merged). @micael.oliveira Is there something that can be done on buildbot side to run these?

Depends on !2155 (merged), !2194 (merged)

Closes: #401 (closed), #402 (closed), #557 (closed), #641 (closed), #638 (closed), #621 (closed)