A North Yorkshire primary school has been praised by inspectors as a 'happy place where friendships and learning flourish'.