Plans for accommodation at a storage site in Houghton-le-Spring have been approved by Durham County Council.