Many serious reef keepers have tried the method of burrying a long (very long) stretch of hose underneath the ground, then pumping water through it.
The hole has to be deep enough so as the temperature during the day does not effect the temperrature to the depth of your hose (you wont want your water to start heating up as the ground warms, because less heat will disipate through the ground). Also, you have to drain the pipe when not in use (stopping the water becoming moldy and stagnant). You also need a significant length of tubing to allow a few degrees of cooling to take place.
There are mini chillers, which are expensive, you can leave the hood off, you can use the esky method, as suggested by McMurray, but use cold ice with water to surround the tubes, (bugger buyin bottles of drink). Or, buy some cheap computer fans and their power supplies (can be bought from shops or fleabay) and run them when your lights are on.