[DPE-5642] Integration tests on self-hosted runners

[dragomirp]

• Update charm libs
• Switch integration tests to self hosted runners

[codecov[bot]]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 75.01%. Comparing base (6c097d1) to head (23bf044). Report is 3 commits behind head on main.

Additional details and impacted files

```diff @@ Coverage Diff @@ ## main #412 +/- ## ======================================= Coverage 75.01% 75.01% ======================================= Files 9 9 Lines 1313 1313 Branches 226 226 ======================================= Hits 985 985 Misses 255 255 Partials 73 73 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

---

🚨 Try these New Features:

• Flaky Tests Detection - Detect and resolve failed and flaky tests

[dragomirp]

DPW changes are on https://github.com/canonical/data-platform-workflows/pull/245