No unfortunately Kindles just do not work with library books.
I used to have a Sony ereader and that did work with library books that were based on the overdrive system which I think covers most/all of the elibraries I know of.
Amazon do provide plenty of free books however (modern as well as old) and they are normally listed on here at mobileread.
Hope you enjoy your new ereader