As a renter and aspiring house-hacker with a pet I have interest in this question from both sides! My rental market has hardly any pet-friendly rentals available, which is disappointing but understandable. Being able to have a pet is is one reason I've stuck with my current apartment for so long.
I would recommend, however, that the pet rider in your lease includes instructions that the tenant needs to keep pets on a leash at all times outside the apartment and they are 100% expected to pick up after their dog. The other tenants in my complex let their dogs off lease all the time and don't always clean up after their dogs, meaning that other people can't use the common area as often as they're entitled to. If you require renter's insurance as well it's a good way to make sure that if a dog hurts someone else that the liability is covered by the tenant.
