A crowd surge at a popular Hindu temple in northern India has left at least six people dead and dozens others injured, local authorities say.