Soggy and watery zoodles are often the result of using larger squash with a lot of seeds.  If you prefer sturdy noodles, opt for smaller zucchini. But do note, you'll also get shorter zucchini noodles!