Thousands turn out for bonfire and fireworks extravaganza