Exploring Geochemical Signatures in Production Water: Insights from Coal Bed Methane and Shale Gas Exploration—A Brief Review