An exhibition at the Fitzwilliam Museum reveals how the home in Renaissance Italy was the site of much private devotion