Portare a means “to lead/bring to” a place. It’s the usual collocation when saying a path “leads to” somewhere.
– Porta in would suggest entering (“leads into”), which can work if you specify being inside something (e.g., porta in città = “leads into the city”).
– Porta verso means “leads toward” and implies direction but not arrival (e.g., porta verso il mare = “heads toward the sea” but doesn’t guarantee you get there).
You could reorder some adjectives—un piccolo sentiero sabbioso is grammatically correct (“a small sandy path”)—but the meaning shifts slightly (you’re emphasizing the path’s size first). Also, you’d change the article to un (masculine indefinite) and adapt the rest of the sentence accordingly:
Un piccolo sentiero sabbioso porta a una baia nascosta.
That still works, though you lose the emphasis on “the” specific path.