After cold nights on Windsor streets, royal super-fans thrilled as big day dawns