Can I get library distribution with my own ISBN number?
Even if you have your own ISBN numbers and you want to have the book available for libraries then you’d need to use a KDP Print ISBN as that is a stipulation for that channel of expanded distribution. How likely are libraries to be to purchase a copy? Standard distribution and expanded distribution (with the exception of libraries and academics) are all fine with your own ISBN; it would only be limited by that one distribution channel.
The only way around that limitation is to not use KDP Print for expanded distribution and to go with another service, such as Lightning Source or Ingram Spark.
If you are not going to promote your book heavily to libraries, you can make your book available through KDP Print with expanded distribution and if it happens, then that’s a bonus. If your strategy will include a lot of promotions to libraries (or book stores) then you should dual publish to both KDP Print (and to turn off expanded distribution) and also to Ingram Spark (or to Lightening Source if you have a large enough catalog.)
Your Amazon sales will be sold through KDP Print, and all other sales will be made through IS or LS. This will give you a higher profit margin and more professional appearance.