Extended stay hotels for the kind of purposes you described already exist. They're essentially a small studio, with a kitchenette, are rented by the week, are larger than a normal hotel room, and have the personnel to ensure safety. The problem with zoning and having hotels in fun residential neighborhoods is that there often isn't the kind of civic infrastructure needed to support such things. Ability to ensure people adhere to noise ordinances, police officers, etc, are all issues that hotels have and need to be planned for.