Myself and my siblings all lived on a fairly large rural farm with 2 large bodies of water that we always hung around unsupervised from about 4 y/o onwards. We loved catching bullfrogs and watching the fishes and stuff. Our mom gave us very strict/scary warnings about never going in and being careful, but other than that we were pretty free thankfully. 5 y/o with a good warning seems totally fine.