Messy play - dig in the mud, make mud from soil and water, mix and stir, make mud pies (and smash them down if he likes) - any chance you can set an area of garden aside for this? Can do similar in sand tray but messy factor of mud often appeals more.
Other hands on/sensory/messy stuff like shaving foam, cooked cheap pasta, dry rice or lentils is good and not necessarily just for younger children. With the dry pasta/rice etc could give some containers for tipping/pouring/shaking in case its noisy play he's after.
Also on a noisy theme - wooden spoon plus a load of old pots and pans for a good old bash and bang around.
If you have a sand or water tray, or big storage tubs etc, you could fill it with gravel or pebbles etc and use for toy cars/diggers/tractors etc - just a bit different and more engaging than the usual.
Save or collect large cardboard boxes etc for building and den making, satisfying to knock down but minimal impact!
Freeze water in different pots - empty yoghurt pots, ice cream tubs, Tupperware etc - you can add food colouring or freeze toy dinosaurs /cars/whatever inside. Then stick in a plastic tray/washing up bowl/paddling pool and let him have at them with toy tools. He could also watch what happens when you sprinkle salt on the ice.