Add `read_nwb_method` for local paths in both hdf5 and zarr

[h-mayorquin]

Motivation

See #1974

How to test the behavior?

I added tests.

Checklist

• [x] Did you update CHANGELOG.md with your changes?
• [x] Have you checked our Contributing document?
• [x] Have you ensured the PR clearly describes the problem and the solution?
• [x] Is your contribution compliant with our coding style? This can be checked running ruff check . && codespell from the source directory.
• [x] Have you checked to ensure that there aren't other open Pull Requests for the same change?
• [x] Have you included the relevant issue number using "Fix #XXX" notation where XXX is the issue number? By including "Fix #XXX" you allow GitHub to close issue #XXX when the PR is merged.

[codecov[bot]]

Codecov Report

Attention: Patch coverage is 18.18182% with 9 lines in your changes missing coverage. Please review.

Project coverage is 91.58%. Comparing base (7087f00) to head (f95ffc5).

Files with missing lines	Patch %	Lines
src/pynwb/__init__.py	18.18%	9 Missing :warning:

Additional details and impacted files

```diff @@ Coverage Diff @@ ## dev #1994 +/- ## ========================================== - Coverage 91.88% 91.58% -0.30% ========================================== Files 27 27 Lines 2711 2722 +11 Branches 707 710 +3 ========================================== + Hits 2491 2493 +2 - Misses 144 153 +9 Partials 76 76 ``` | [Flag](https://app.codecov.io/gh/NeurodataWithoutBorders/pynwb/pull/1994/flags?src=pr&el=flags&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=NeurodataWithoutBorders) | Coverage Δ | | |---|---|---| | [integration](https://app.codecov.io/gh/NeurodataWithoutBorders/pynwb/pull/1994/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=NeurodataWithoutBorders) | `72.63% <18.18%> (-0.23%)` | :arrow_down: | | [unit](https://app.codecov.io/gh/NeurodataWithoutBorders/pynwb/pull/1994/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=NeurodataWithoutBorders) | `82.58% <18.18%> (-0.27%)` | :arrow_down: | Flags with carried forward coverage won't be shown. [Click here](https://docs.codecov.io/docs/carryforward-flags?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=NeurodataWithoutBorders#carryforward-flags-in-the-pull-request-comment) to find out more.

: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