No, you don't need to make a second 's' sound for 'the cats' home' etc.
When names end in an 's' sound, like 'Nicholas', for example, when you make that into the possessive form, as in 'It's Nicholas's bag.' - then you need to make the extra 's' sound -almost like 'Nicholasiz bag.'.
- For Teachers