No. 'Temperate' is generally used for climate. For example, the UK has a temperate climate, meaning that it doesn't experience extremes of temperature. For water temperature, you would say 'tepid' or 'lukewarm'.