Sedation Is Unlikely
It is highly unlikely a veterinarian would sedate a dog specifically for Bonfire Night. Sedation is a serious medical procedure with risks and should only be used when absolutely necessary.
Better Alternatives
Vets can offer behavior modification techniques, anxiety medication, and environmental enrichment such as white noise or calming music. Sedation can sometimes make the situation worse by reducing the dog's ability to cope.
If your dog is anxious about fireworks, consult your vet to find the right solution.