That particular variant is called a gunstock warclub. However, they aren't as far as I can tell, PC for mid-18th century NY, but show up in the Mid-West areas around 1800. The ball-headed warclub and elusive saber-type club were the types used in the NE during the French and Indian Wars.
Chingachgook's club is somewhat supersized compared to originals, too. Good dimensions are hard to come by, but I've heard that whhile broad in profile they are no thicker than 1" or so through the mid-section and are quite narrow at the edges, so even though fairly light all the force is concentrated in a fairly small point. I'm working on a copy of an honest-to-goodness Mohican saber-style fish effigy club, kind of the ancestor to the gunstock type (and the model the move should have used for C's club!) and it is quite light but obviously capable of cracking a skull or critical bone if swung with much force.
Actual fighting percussion weapons tend to be much smaller than Hollywoood would have you think.