[Misc] Apply SonarCloud rule cpp:S1003

Description

Do not use "using namespace" directives in header files

Checklist

• Documentation reflects the changes made.
• Merge Request title is clear, concise, and suitable as a changelog entry. See our contributing docs

References

Closes #1405 (closed)