Properties are now falling over themselves to include pets – from beds and bowls to spa treatments and even commissioned portraits