Hi Becky
When my boys were younger (now 22 & 19) we went to Centre Parcs for New Year. The boys, being very sporty, loved it there (swimming, biking, skating, golf, tennis football courses etc) and the choice of bars and restaurants means something for everyone - nothing closed for bank holidays - it was usual open hours all year round.
1/2 hour before midnight NYE there was a torch lit procession through the park and then an amazing firework display over the lake.
We always went to Elveden Forest but I'm sure they have a centre parcs in Cumbria now.
Just an idea (and a nice trip down memory lane for me).