Picture-Perfect Science Lessons and More Picture Perfect Science Lessons, both written by Karen Ansberry and published by the National Science Teachers Association.
These books provide complete lessons based on children's picture books, including ready-to-copy handouts for students.
I would say the lessons are largely geared to elementary aged students, though things can be adjusted up or down to meet other groups' needs.
They're really nice books, but seem to be a bit pricier than some, at least at the sources I've checked. With a little bit of work you may be able to get them through your library, if you want to check them out before making the investment. My local library system didn't possess either book, but they maintain an affiliation with some of the state universities, at least one of which did have the books in their collection. It took a little more time and effort (on my librarian's part) than a regular book request, but with my librarian's help, I was able to get my hands on the books without laying out any money. It's certainly worth striking up a conversation with your local librarian and seeing if it's a possibility for you.