Drinking enough water to keep ourselves hydrated is more important for health than its temperature when consumed. So, it does not matter whether water is cold or warm. Under normal circumstances, the energy our body expends to bring the temperature of water or food we eat closer to inner core temperature is negligibly low.
A lot of people like the taste and feel of drinking cold/beverage water in hot weather or hot water in cold weather. It's just personal preference. Interestingly, cold water is absorbed faster than warm water through your intestine, so drinking cold water after an intense workout can hydrate you and bring the core temperature back to normal "slightly, but not significantly" faster than warm water. Also, in rare cases, swallowing/gulping down cold water/beverages can cause bradycardia (abnormally slow hearbeat), headache, or syncope (temporary loss of consciousness caused by a fall in blood pressure) in few individuals.