Three new cancer treatments are to be made available on the NHS in Scotland, as six drugs are given the green light for use.