Health trust apologises after patient told to use ‘community-based’ options such as machines in shops intended for animals