Thermally fluctuating second-order viscous hydrodynamics and heavy-ion collisions