The Google Sites team has released this to everyone now on all domains, the embed code feature, which allows you to insert custom code. HTML, CSS, Javascript allow for some fun widgets to be inserted like slideshows, accordions, pagination, social media, twitter, instagram, etc.
