In which Scary movie does the guy from Scream appear at beginning and tries to kill girl but he is stupid?

The character you're referring to is Ghostface, who appears in the firstScary Movie. He is portrayed by Roger L. Jackson and is a parody of the Ghostface character from the Scream series. In Scary Movie, Ghostface attempts to kill Cindy Campbell (played by Anna Faris) at the beginning of the film, but she manages to outwit and kill him.