Resolve "(core): core tests fail when running with the current path containing a symlink"

Description

All modules and libraries' paths are now correctly located when encountering symlinks.

I took the opportunity to upgrade sight version to 24.0

How to test it?

As already described in #1210 (closed) :

• mv /path/to/build_folder /other/place
• ln -s /other/place /path/to/build_folder
• bin/core_ut -> OK
• bin/core_detail_ut -> OK

We can also check that tests pass if the windows build is executed on IRCW225.

Closes #1210 (closed)