3-year-old rescue pooch Major had reportedly been displaying aggressive behavior, including jumping, barking and charging at White House staff and security