The fishing hole in Twilight Princess can be found in Upper Zora’s River. You can get there by heading towards the northeast and following the river until you reach the wooden bridge. The fishing hole is located right below it.