In the US and I would expect Canada as well Overdrive is supported but not required for eBooks in most libraries. ADE DRM is needed which can be via the installed reading app. Overdrive is needed for audio books. See
EBook Lending Libraries in our wiki.
Dale