There’s a lake north-northeast of Dro’dara plantation wayshrine. You will see steps that lead up to Aphren’s Hold ruins (steps are left on the screenshot above). Skyshard is actually on the top of the waterfall you see on the picture above.
As you climb the stairs you should see the shard shining.
Sand Kingdom Moons - Super Mario Odyssey Power Moons