Zhouzhuang is generally considered a day-trip destination. If you're staying in Shanghai or Suzhou, it's possible to see most things the village has to offer and make it back in a day.
That said, there are still a number of charming places to stay. Most of Zhouzhuang's hotels are situated along the river and prices range from around 100 to 300 RMB a night.