My compost piles are made out of pallets, and I just used metal fenceposts (2 per pallet) to hold them upright. On the front pallet, I used short posts (about 24") so it's easy to just lift off the front pallet to mix and remove compost. I have 2 bins next to each other (as one gets full or ready to use I just use the other) and I'm planning on adding a 3rd. Not the most gorgeous thing, but it's in the back of the yard next to a shed, under a tree. I've never had a problem with smell, even when I stand right next to it to work, it just smells like damp woodland soil. If you keep the balance right, it shouldn't smell. Also, burying smelly components (poo, kitchen scraps) under a layer of dry browns will help.
Also, I personally never water the pile, but it's shaded all summer. I probably would if it got some sun. I also rarely turn, maybe a month or so before I want to use it. I'm into the easy method, not the method that works the fastest, since I have enough room for several piles.