The Bottom of the Well can only be accessed as a child Link. As an adult, you must obtain the Song of Storms from the Phonogram Man in the Kakariko Village windmill. Next, play the song inside of the windmill as a child. This will cause the water to drain from the well, granting access to the dungeon.