I usually find the hotel chain with the puppets TV advert, those who provide lodges for people who travel (can we name hotel brands on here?) the best for discretion and price. They do have a reception, but half the time they are un-manned and if they are staff don't give a toss who is coming in and out.
Plenty to choose from in Sheffield/Chesterfield area.