I've seen quite a few that execute the coffee shop idea nicely!

The main branch of the Ottawa Public Library has a nice little coffee/food shop in the middle of its main floor.

I've also visited two public libraries in smaller cities north of Toronto recently, and they also have similar shops. I think it is a great idea, as I will sometimes go to the library to work for the day and don't even have to leave the building for lunch.