The lease agreement for my apartment for example says I can sublet but I can't allow my tenants to sublet so I don't think I could use it. I don't know if that's common outside of London.
What's in it for the tenant though? If an individual needs that level of flexibility but want something beyond a hotel then there are options such as serviced apartments in most major cities.