The waterfront station is in front of the cruise terminal. This is where you can easily pick up the translink to go to the airport. This is also where you can buy a day pass for public transportation in Vancouver. Buy it for 9,75 Canadian dollar at the machine.
Waterfront station, Vancouver