They are both correct, but I would say that I consider the difference to be what is implied:
Let the door BE opened (implies that it is being opened BY someone/something).
Let the door open (could easily mean it is being opened by someone, or perhaps opened by itself or just falls open?)
I hope this is helpful :-)