North Yorkshire Council spending more than £1 million on care for some individuals