Hi Helen
We live just up the road from Conkers in Derbyshire (not sure whether you would consider this area, but not too far away from Nottingham). There is a Caravan and Camping Club site at Conkers too. They have a fantastic firework display, along with bbq, rides for the children, face painting etc .... The fireworks are fantastic.
Sam