When you are young link, stand on the island above the gate to the water temple. Go to the part of the island where it starts to curve downwards toward the water, but make sure it is just above the gate. Now use C-up to look down as far as you can. You will hear a noise for a while and then a boom. What you just did was open the Water Temple.