Too many variables to answer you directly.
By “overnight” I aasume you mean sitter stays on the property?
How many dogs/cats/housepts?
How many horses?
What is involved in feeding, turnouts, etc.?
I have paid farmsitters - who do NOT need to stay onsite - as much as $15/visit & have them come 2X daily to feed horses.
My 2 horses are out 24/7 with access to stalls & come in by themselves to be fed.
Frostfree hydrant inside the barn has attached hose that easily reaches both stalls and just outside the barn is a 50gal barrel also reachable from inside the barn for refilling.
I do not ask that stalls be picked aside from forking manure piles inside them into a wheelbarrow in the aisle. This is for when I’m only gone 2-3 days.
If I’m gone longer I just ask that piles be tossed into the paddock & I deal with that when I get back.
Housecat gets checked on every couple of days to make sure she has water & dry food.
Barncat gets dry food only & then only if she appears - no leaving food out for varmints.
I consider this a pretty easy job & pay accordingly.
Present farmsitter is paid $10/visit - actually, he did not want to charge me at all, but I feel someone coming twice a day should get something.