Singin’ in the Rain has an unparalleled ability to capture pure glee and is well deserving of its status as one of Hollywood’s most iconic films, writes James McCafferty