I'm curious because the way I heard the story it went something like, "they needed the House to get the big states to agree to the Constitution, and they needed the Senate to get the small states to agree". That also has the effect you're talking about, but I never heard that it was deliberate. I would be interested in why they set it up that way.
"In this spirit it may be remarked, that the equal vote allowed to each State is at once a constitutional recognition of the portion of sovereignty remaining in the individual States, and an instrument for preserving that residuary sovereignty. So far the equality ought to be no less acceptable to the large than to the small States; since they are not less solicitous to guard, by every possible expedient, against an improper consolidation of the States into one simple republic.
Another advantage accruing from this ingredient in the constitution of the Senate is, the additional impediment it must prove against improper acts of legislation. No law or resolution can now be passed without the concurrence, first, of a majority of the people, and then, of a majority of the States. It must be acknowledged that this complicated check on legislation may in some instances be injurious as well as beneficial; and that the peculiar defense which it involves in favor of the smaller States, would be more rational, if any interests common to them, and distinct from those of the other States, would otherwise be exposed to peculiar danger."