Life Cycle Assessment and Water Footprint of Hydrogen Production Methods: From Conventional to Emerging Technologies