Preparation towards 2024.0 release

[antonwolfy]

The PR pins DPC++ and OneMKL versions to pre-released ones from upcoming 2024.0 release. The PR updates cmake files to use MKL::MKL_SYCL instead of alias on old name MKL::MKL_DPCPP.

The PR removes the temporary workaround with cmake scripts copied from OneAPI BaseKit 2023.0 and stored previously in dpnp repository.

• [x] Have you provided a meaningful PR description?
• [ ] Have you added a test, reproducer or referred to issue with a reproducer?
• [ ] Have you tested your changes locally for CPU and GPU devices?
• [ ] Have you made sure that new changes do not introduce compiler warnings?
• [ ] Have you checked performance impact of proposed changes?
• [ ] If this PR is a work in progress, are you filing the PR as a draft?