I've not been to Calgary or Banff but know many who have. The vistas on the course are apparently fantastic.
Banff is a very popular tourist area and the golf a resort course but you should be able to get on with advance planning.
other area courses that are well regarded include Silvertip and Kananaskis.
If you are there at the correct time the Calgary Stampede would be a huge must do.
a day trip to Banff or Lake Louise