Waters closed following Cape Cod shark attack; beach manager says people will need to use 'common sense' after fatal incident