Two fixed drug-testing clinics will be established in Brisbane in 2024 after the Queensland state government committed $1m to roll out the service.