In the short term, prevention is going to be the best way to curb this behavior, either by fencing off the route to the shop/garage (you can use livestock fencing/netting for a relatively inexpensive and removable option) or by confining the dog to a smaller portion of the property where he doesn't have access to that area.
How much physical exercise would you say he's getting each day? There's a big difference between five minute play sessions and 45 minute ones, for example. For most dogs, leaving them out in a fenced yard - even a large fenced yard - by themselves doesn't count much towards sustained physical exercise, because they don't spend much time actively running around on their own accord, so play/walks really matter. And is any of that play actually training, focused enrichment, or otherwise mentally challenging? He's a mix of intelligent, incredibly active breeds that need both physical and mental stimulation. As an outside dog, he's also not going to get as much interaction as an inside dog would unless you're literally out there with him most of the day (think working farm dogs), so you have an even harder job making sure he gets all his mental and social needs met.
He sounds like he gets so excited and overwhelmed to see people that his brain falls out and he has no self control or inhibition. Some of this is likely due to age - he's very likely still an adolescent in terms of mental development - but that doesn't mean it's something I'd trust him to 'grow out of', especially since the behavior is potentially dangerous. Not because he's a bad or aggressive dog, just because he could really hurt someone knocking them down or bodyslamming them. Pick either 'sit' or 'down' and work like crazy on training it in less exciting circumstances. Make it a part of his daily life. Using 'sit' as the example, have him sit before you pet him, before you give him his dinner, before you greet him, before you offer him a toy or chew, before he jumps in or out of the car. Work up to more exciting situations - ask him to sit as you throw a toy, then cue him to go fetch, sit before starting a game of tug, sit and stay as you walk away, then recall him to you, etc. I'm just using generic examples - some of these the 'less exciting' things might be too exciting to start with for him personally - but just giving you an idea.
What you want to get to is being able to interrupt excited behavior with a 'sit', to have it become so instant and automatic that, when he's charging towards you, asking for a 'sit' means he practically slides his butt across the ground before he stops. When you reach this point and consistently demand a 'sit' instead of allowing the charge, then rewarding that sit with some attention and pettings (and maybe a treat or quick game at the beginning), he'll start running up and sitting instead of slamming into you or nipping. But it takes time and consistency, hence why it's important you figure out a way to stop him from charging in the meantime. This is, for the record, more or less how I dealt with my youngest's habit of charging and launching himself at us when he was excited. He's not perfect, but much, much improved and easily reminded with a quick hand signal that he needs to put his butt on the ground if he wants our attention. He is not a herding breed, but I know we have some herder-savvy members here so hopefully someone will be able to speak more towards those breeds/behaviors.
How much physical exercise would you say he's getting each day? There's a big difference between five minute play sessions and 45 minute ones, for example. For most dogs, leaving them out in a fenced yard - even a large fenced yard - by themselves doesn't count much towards sustained physical exercise, because they don't spend much time actively running around on their own accord, so play/walks really matter. And is any of that play actually training, focused enrichment, or otherwise mentally challenging? He's a mix of intelligent, incredibly active breeds that need both physical and mental stimulation. As an outside dog, he's also not going to get as much interaction as an inside dog would unless you're literally out there with him most of the day (think working farm dogs), so you have an even harder job making sure he gets all his mental and social needs met.
He sounds like he gets so excited and overwhelmed to see people that his brain falls out and he has no self control or inhibition. Some of this is likely due to age - he's very likely still an adolescent in terms of mental development - but that doesn't mean it's something I'd trust him to 'grow out of', especially since the behavior is potentially dangerous. Not because he's a bad or aggressive dog, just because he could really hurt someone knocking them down or bodyslamming them. Pick either 'sit' or 'down' and work like crazy on training it in less exciting circumstances. Make it a part of his daily life. Using 'sit' as the example, have him sit before you pet him, before you give him his dinner, before you greet him, before you offer him a toy or chew, before he jumps in or out of the car. Work up to more exciting situations - ask him to sit as you throw a toy, then cue him to go fetch, sit before starting a game of tug, sit and stay as you walk away, then recall him to you, etc. I'm just using generic examples - some of these the 'less exciting' things might be too exciting to start with for him personally - but just giving you an idea.
What you want to get to is being able to interrupt excited behavior with a 'sit', to have it become so instant and automatic that, when he's charging towards you, asking for a 'sit' means he practically slides his butt across the ground before he stops. When you reach this point and consistently demand a 'sit' instead of allowing the charge, then rewarding that sit with some attention and pettings (and maybe a treat or quick game at the beginning), he'll start running up and sitting instead of slamming into you or nipping. But it takes time and consistency, hence why it's important you figure out a way to stop him from charging in the meantime. This is, for the record, more or less how I dealt with my youngest's habit of charging and launching himself at us when he was excited. He's not perfect, but much, much improved and easily reminded with a quick hand signal that he needs to put his butt on the ground if he wants our attention. He is not a herding breed, but I know we have some herder-savvy members here so hopefully someone will be able to speak more towards those breeds/behaviors.