A stunning palace on a major canal in Venice is up for sale for the impressive sum - but it's known by locals for a chilling reason.