For general geology Marshak's Portrait of a Planet is a really good place to start, then for sedimentology, Sedimentary Rocks in the Field is great and does exactly what it says. Sedimentary Structures by Collinson I found quite useful and then something like Facies Models 4 to get a better idea of facies analysis.
As far as hydrogeology goes, I've just finished my hydrogeology module at university and haven't been recommended any books. The lecturer wasn't great and because a lot of the books seem to be quite old or just poorly written none of us used them. I think searching for individual topics and papers may be your best chance, then hopefully they'll lead you to something useful. Sorry I can't be of more help on that area.