Use the adjective winding to describe something with twists and turns, like a winding country road or a little winding mountain stream.
A path through the woods that has plenty of bends and curves in it is winding, and a river that curls and meanders down to the sea is also winding. The Beatles song "The Long and Winding Road" describes a twisting, indirect road. Winding has an Old English root, the word windan, which means "to turn, twist, or wind." Similar words such as ‘windlass’ have the same root.
Definitions of winding
[noun] the act of winding or twisting
twisting, meandering, torturous
rotary motion, rotation
the act of rotating as if on an axis
[adjective] marked by repeated turns and bends
tortuous, twisting, twisty, crooked
having or marked by bends or angles; not straight or aligned
A winding hole is unlikely to have anything to do with the wind. It is simply the turning of a boat marked by repeated turns and bends.