A three-metre-high steel ram is to be placed at the entrance of an historic Cumbrian market town as a gift by a renowned local sculptor.