I'm playing the game for the first time and I'm pondering attacking Hougomont. The stacking limit is 1, so does this mean I can only move 1 unit into the attack supported by artillery and leaders?
Correct. one unit per side in a red area. As you say, it can be supported from adjacent areas.