Huddersfield is in West Yorkshire so you could stay anywhere in the county. I'd recommend staying in Holmfirth if you want to be really near to the ground. For a city break you should stay in Leeds - there's loads to do. In Halifax there is the Eureka museum which would be ideal for your children. If you want to stay somewhere special I'd go to Ilkley which is really beautiful with quite a few hotels and a huge outdoor lido.