hi guys sorry if people have already answered or given similar posts I haven't read all the way through but i thought i would give some ideas. feel free to ignore.
sandtrout: sand trouts roll in the ecology of dune is to trap and remove water to protect the worms, sand trouts are earliest stage worms. they can be caught and 'drunk' in emergencies, this is also a fremen childs game. In game terms sand trout could be a bonus that provides small water, very small, but a big bonus could be gained with an improvement such as 'predatory fish pond' (feel free to think of a better name) but fremen seeded predator fish in their water stores to keep the sand trout from massing and removing the water.
Water: In the poles smugglers and others setup ice collecting sites this is then taken to the main city and sold by water merchants. Water was often imported at huge cost from other worlds, and when Paul became emperor he began forcing other worlds to pay water tributes. You could maybe make Smuggler camp/dens as terrain improvements or bonuses with the attached improvement being a smuggler contract. Providing water/food possibly even production as the smugglers import equipment. Even the Fremen dealt with smugglers usually as a connection to supply the Spacing Guild and CHOAM with off the books spice in exchange for secrecy as to their numbers and networks, obtained by the survey satellites in orbit.
Food: the fremen eat massive amounts of spice 'spice cakes' 'spice tea' etc. in fact spice is even used to make rugs and things, they also talk about rock gardens and plantations buried in rocky crevices and inside certain types of rock formations and caves, places where the sand can't get into and destroy. where they cultivate flowers fruits and vegetables. I do think for the other peoples that a huge amount of stuff is imported the only reason anyone, other than fremen, live on dune is because of the necessity of spice and its vast financial rewards even after the costs of water and food imports.
sandtrout: sand trouts roll in the ecology of dune is to trap and remove water to protect the worms, sand trouts are earliest stage worms. they can be caught and 'drunk' in emergencies, this is also a fremen childs game. In game terms sand trout could be a bonus that provides small water, very small, but a big bonus could be gained with an improvement such as 'predatory fish pond' (feel free to think of a better name) but fremen seeded predator fish in their water stores to keep the sand trout from massing and removing the water.
Water: In the poles smugglers and others setup ice collecting sites this is then taken to the main city and sold by water merchants. Water was often imported at huge cost from other worlds, and when Paul became emperor he began forcing other worlds to pay water tributes. You could maybe make Smuggler camp/dens as terrain improvements or bonuses with the attached improvement being a smuggler contract. Providing water/food possibly even production as the smugglers import equipment. Even the Fremen dealt with smugglers usually as a connection to supply the Spacing Guild and CHOAM with off the books spice in exchange for secrecy as to their numbers and networks, obtained by the survey satellites in orbit.
Food: the fremen eat massive amounts of spice 'spice cakes' 'spice tea' etc. in fact spice is even used to make rugs and things, they also talk about rock gardens and plantations buried in rocky crevices and inside certain types of rock formations and caves, places where the sand can't get into and destroy. where they cultivate flowers fruits and vegetables. I do think for the other peoples that a huge amount of stuff is imported the only reason anyone, other than fremen, live on dune is because of the necessity of spice and its vast financial rewards even after the costs of water and food imports.