A major fire has broken out at a sports club in Nambucca Heads on the NSW Mid North Coast.