Competing charge-density wave instabilities in the kagome metal ScV6Sn6