Not currently possible to automate this. You can easily do this by creating the resource as "hidden", then "un-hiding" it yourself on the start date and "hiding" it at the end date.
There is some work going on which will make this kind of thing possible in future.