If I was able to get free sand delivered and I needed to create a
berm sound barrier, then I would go with it, unless it was possible to get the native dirt for free.
I would then add as much
wood chips & biomass as I could get my hands on.
If you have access to dig out the dirt where you would like your hugel berm and put this dirt on top of your berms, then most of your plants would likely be quite happy with the lower levels of the berm with sand and the upper layers of woodchips and natural soil. You might like to test the ph of your berms to make sure your plants like the ph level of your berms.
If you are unable to dig out the natural dirt and lay that on top of your sand berm, then continue adding wood chips and if you can get access to your native dirt. The wood chips and other biomass are key to making any dirt or sand a great growing medium.
The thing I like about
permaculture is that one can always improve the dirt, soil or sand with wood chips or other biomass to make things grow in them. Just choose your plants in accordance.