Cosying up to the dog at night really is good for your physical and mental health - but sharing a bed with the cat won't leave you feline better.