Hackforth and Hornby Church of England Primary School, near Catterick Garrison, will close in August due to declining pupil numbers and financial challenges.