Where does the water come from that is given off when making an ester?

One hydrogen (-H) from the alcohol group (-OH) on the alcohol breaks off and joins with the alcohol (-OH) group that breaks off of the carboxylic acid (-COOH).

So the -H from alcohol joins the -OH from carboxylic acid to form H2O.