It’s a black rat snake, Elaphe obsoleta, in case you’re wondering. Videography courtesy of the house programmer. Frightening of the snake courtesy of the house dog.
The tail shaking is just a bluff. The noise is just from the movement of the leaves underneath the tail. They also kink up their bodies when frightened, and will curl up and strike a bit. I’d worry more about the dog or the programmer. The dog is very happy and will push you over, and the programmer sometimes will trip on you.