For a good theory book; Handbook of Aviation Meteorology Met O 630 (AP3340). The original RAF Met Reference book.
For a good practical book, Pilot's Weather by Brian Cosgrove is about as good as you will find anywhere. As well as being a microlight pilot, he was a Flying Met Observer during the war.