Not for me, sneaking for me is quite easy due to 100 sneak with most sneak perks + illusion.
For a follower, I would enchant muffle and fortify sneak for him. Could work. Just can't find any muffle enchantments.
Protip: Your followers won't sneak anyway. Yes, they sneak with you while you're sneaking, but if you tell them to kill something, they won't do so stealthily, and the moment the enemy goes into alert they will stop sneaking again and rush headlong into battle. Even if you give them Muffle boots (enchanted or pre-made). I mean, I have Cicero with me, we're in the same exact armor (the Jester suit, which the boots have Muffle on them) and he STILL doesn't sneak attack people when told to attack while sneaking.
If they are sneaking with you, even without the boots, it won't set off the enemy's "sound" detection, so far as I can tell.