Police have released shocking CCTV footage showing the moment a man is gunned down on a street in Melbourne.