Councillors have given their enthusiastic support for a campaign to create an outdoor tidal pool in Scarborough.