The Eurovision Song Contest's final is underway with tight security and rainy weather failing to dampen fans' enthusiasm.