The case against a man accused over the fatal shooting of a young father in a crowded nightclub has been dropped.